Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
I cannot seem to do a SQL Select with a where clause
Message
 
À
10/12/1999 16:37:54
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvanie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00301982
Message ID:
00302154
Vues:
36
>>=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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform