>>Is there some reason why the below statement does not work if I include svar?
>>
>>svar='RM 113'
>>SQLExec(lnHandle,"SELECT * FROM amcs_inventory_data where;
>>svar $ location","Result1")
>>sele result1
>>brow
>
>Try:
>
>
>SQLExec(lnHandle,"SELECT * FROM amcs_inventory_data where " +;
> "'" + svar "'$ location","Result1")
>
>Although I don't think the $ operator would be supported through the ODBC driver.
I tried this and it comes back with "Function name is missing ). "
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."