General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Pass-Thru basic question
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only