>I am trying to use inlist for integer values but I keep getting errors saying invalid oprand/mismatch. Is the following type of query valid?
>
>
>select sub_key.sub_key,sub_vendor from sub_key where sub_key.main_keys = 7450 AND sub_key.sub_key = INLIST(sub_key.sub_key,93,97,352,354,355) into cursor blah
>
>
>thanks
>Nick
Nick,
INLIST() function returns logical true or false.
If you want to select some sub_keys USE IN syntax (SQL Server compatible)
AND Sub_Key.Sub_KEY IN (93,97,352,354,355) into cursor blah
If it's not broken, fix it until it is.
My Blog