how to transactions with Cursoradapters and sql

I have created a CursorAdapter to insert and update multiple records in a
SQL table.A

After updating/inserting multiple records or so, i need to be able to roll
this action back.
At the moment, if i issue a TABLEUPDATE(.T.), then all the changes are
commited, even if i use a TRANSACTION in the SQL (by issuig BEGIN
TRANSACTION and ROLLBACK in SQLEXEC for the same connection handle stored in
the CursorAdatper).

How can i rollback the changes after having issued a TABLEUPDATE(.T.)?


.

Relevant Pages

  • Re: ODBC or OLE DB
    ... I'm using Native for the cursoradapter with VFP backend, and ODBC for the ... SQL and that would then use the OLE DB connection string but would that mean ... What I'm trying to do is use a consistent way of interfacing between our VFP ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Interpolation Query...
    ... I follow your interpolation math but the SQL ... variables and then my main query will do the interpolation correct? ... Why then do i get multiple records back. ... >> when I reopen the qury in the designer the brackets are back. ...
    (microsoft.public.access.queries)
  • Re: Using VFP Again...syntax question
    ... Check out the CursorAdapter in Help. ... Blog: http://spaces.msn.com/members/cindywinegarden ... My previous experience tells me to create an updateable remote SQL ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Interpolation Query...
    ... I follow your interpolation math but the SQL ... > query is a little bit over my head and im trying to grasp what its ... > Why then do i get multiple records back. ... >> edit the SQL statement in the SQL view only. ...
    (microsoft.public.access.queries)
  • Re: Best approach to connecting to SQL Server - SQL Commands, Cursor Adapter or ADO
    ... > updates data via stored procedures, ... automatically generated SQL. ... are sure you'll stay with MS SQL Server. ... But CursorAdapter won't have more rights and be able to do more ...
    (microsoft.public.fox.programmer.exchange)