Message
From
15/03/2010 12:03:07
To
Todo
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
SQL Exec & transaction management
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
ID da thread:
01454579
ID da mensagem:
01454579
Views:
101
Hi
I'm using the following command to return a dataset with a single record:
lnConnectionID = SQLConnect('myRemoteSQLSource', 'myAccountName', 'myPassword')
lnCandidate = SQLExec(lnConnectionID, 'exec Candidate_Select_CandidateID ?lnCandidateID', 'myResults')
If I want to be able to edit the contents within myResults, and then commit the changes back to SQL Server 2005, what would the syntax be to set this up and then perform the relevant commit. The stored procedure selects a single record, and although it's unlikely that anyone else would have this record open at the same time, I have to take this into consideration just in case.
Regards
I'm using the following command to return a dataset with a single record:
lnConnectionID = SQLConnect('myRemoteSQLSource', 'myAccountName', 'myPassword')
lnCandidate = SQLExec(lnConnectionID, 'exec Candidate_Select_CandidateID ?lnCandidateID', 'myResults')
If I want to be able to edit the contents within myResults, and then commit the changes back to SQL Server 2005, what would the syntax be to set this up and then perform the relevant commit. The stored procedure selects a single record, and although it's unlikely that anyone else would have this record open at the same time, I have to take this into consideration just in case.
Regards