Re: how to transactions with Cursoradapters and sql

From: Christian Ehlscheid <christian@xxxxxxxxx>
Date: Wed, 18 Jan 2006 15:22:23 +0100

Hello,

set the UseTransaction property of the CursorAdapter to .F.

Additionally sending BEGIN TRANSACTION/ROLLBACK commands over SQLEXEC is not recommend since the ODBC driver state can get out of sync.

Use the provided FoxPro functions instead.

&& switch to manual transactions
SQLSETPROP(yourConnection,'Transactions',2)
IF TABLEUPDATE(.T.)
	SQLCOMMIT(yourConnection)
ELSE
	SQLROLLBACK(yourConnection)
ENDIF
&& back to automatic transactions
SQLSETPROP(yourConnection,'Transactions',1)

Regards
Christian
.

References:
- how to transactions with Cursoradapters and sql
  - From: Nikki

Prev by Date: Re: multi threading/tasking?
Next by Date: Re: how to transactions with Cursoradapters and sql
Previous by thread: how to transactions with Cursoradapters and sql
Next by thread: Re: how to transactions with Cursoradapters and sql
Index(es):
- Date
- Thread