>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
Did you look at
How to make SQL Pass-Through cursor updatable FAQ #8153 ?
If it's not broken, fix it until it is.
My Blog