Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to SQL Server
Message
From
08/10/2002 16:16:08
 
 
To
08/10/2002 14:45:30
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00708932
Message ID:
00708989
Views:
20
David,

>What is the quickest way to query records from a SQL Server table?

Try this sequence:
 nSQLHandle = SQLconnect (cSQLDataSource, cSQLUserId, cSQLPassword)

 If nSQLHandle = -1
    << your error handling routine >>
 endif
 
 cSQLString = "Select ... From ..."

 SQLexec (nSQLHandle, cSQLString, "ResultCursor")

 Select ResultCursor
 Browse
See SQLconnect() and SQLexec() in the help file for details.

Hope it helps,

Fernando
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform