dynamically create sql string

[spinkung]

Hi all,

I'm trying to create a sql string which i want to use mre than once by using values from arrays.

i have this...

sql = "select * from [COLOR="Red"]'" & query_name(iQuery) & "'[/COLOR] " & _
"where courier = '" & Courier(iCourier) & "' " & _
"and [Claim Type] in (""" & claim_type(iClaim_Type) & """) "

...It's getting stuck on the highlighted part where i'm trying to pass in a query name. All i'm getting is a type mismatch error. It seems to work with the others params though???

Anyone?

Thanks,
Spin.

 

[wh00t]

try

sql = "select * from " & query_name(iQuery) & _
"where courier = '" & Courier(iCourier) & "' " & _
"and [Claim Type] in (""" & claim_type(iClaim_Type) & """) "

 

[spinkung]

perfect, thanks whoot.