Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlconnect question
Message
 
To
24/09/2001 15:53:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00560172
Message ID:
00560188
Views:
19
>>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."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform