Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server and FoxPro
Message
From
11/10/2000 13:10:00
Erin Eby
Mission Critical Software
Gainesville, Florida, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Server and FoxPro
Miscellaneous
Thread ID:
00427928
Message ID:
00427928
Views:
48
Hi all! Happy Wednesday! I have a question concerning sql server and updating tables. I am connecting to the sql server using an sqlconnect statement. After getting a successful connection, i am using an sqlexec statement to grab records from the sql table and put them into a cursor:

ln_exec = SQLEXEC(ln_connect, "SELECT * FROM sqltable", "c_cursor")

After updating my cursor within FoxPro, I need to send the updated records back to sqltable. I have been told that i can use ADO to update that table (sqltable). I have never worked with ADO, and the only way I know to do it is using an API (stored procedure) that is stored on the sqlserver as well. I am attempting to use ADO, but I need a little direction. Any clues? tia... :)
Next
Reply
Map
View

Click here to load this message in the networking platform