Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass-Thru basic question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Pass-Thru basic question
Miscellaneous
Thread ID:
00553577
Message ID:
00553577
Views:
40
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.

Thanks,
Randy
Next
Reply
Map
View

Click here to load this message in the networking platform