Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I cannot seem to do a SQL Select with a where clause
Message
 
To
10/12/1999 16:37:54
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00301982
Message ID:
00302154
Views:
35
>>=SQLEexec(nHandle, "select ContHist.RecID from ContHist where INLIST(ContHist.ResultCode,'EXP','BXP')", "ThisCursor")

>Now that i look it up in help, i understand that i've never seen it because we haven't moved out of the darkness and into the light of remote data sources.

It took me quite a while to figure this out. Even in the wizard in FoxPro I could never put a filter condition and get it to work. I'm going to try the suggestion above and see it it works.

Letcha know in a couple of minutes.

Thanks

DJ
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform