Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Pass-Thru basic question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00553577
Message ID:
00553579
Vues:
14
>OK, I've decided to learn how to use VFP with SQL Server. I've got my SQL
>Server. I've got my ODBC connection. I know how to create Remote Views and
>use them. Now, what about SQL Pass-Thru? I can create conenctions, execute
>commands, and browse the resulting cursor. But my basic question, probably
>something obvious that I am missing, is how in th eheck do I use SPT in a
>form? IE, for a simple example, I want to create a form where a user types a
>user name and password, and then clicks a command button. I then want to find
>that user name in the SQL table, and if found, see if the password matches.
>Or, user enters a search criteria and a value to search for, which populates
>a list box with the hits, if there are any. I've done both using RV's, now I
>want to learn how to do it with SPT, if possible.

If you pass the third parameter to SQLEXEC(), you'll get a cursor back with that name instead of a browse window.

Is that what you meant, or is your question more complex?
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform