Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
SQL Exec & transaction management
Versions des environnements
Network:
Windows 2003 Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement