Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec - update/rollback
Message
From
16/03/2010 16:22:51
Derek Chapman
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLExec - update/rollback
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01454933
Message ID:
01454933
Views:
102
Hi

I have used the following command to remotely retrieve data from SQL Server 2005:

lnConnectionID = SQLConnect('myConnection', 'myDatabase', 'myPassword')
lnReturnCode = SQLExec(lnConnectionID, 'exec Candidate_Select ?lnCandidateID', 'ltCandidateData')

The correct Candidate data is returned, but how would I go about committing the changes back to SQL?

Regards
Next
Reply
Map
View

Click here to load this message in the networking platform