>Again, thank you for bringing up the UseTransactions property. The default value for this property is .T. and I never touched it in my CA object. And the VFP help says
>
>
>The settings for the UseTransactions property are:
>
>Setting Description
>True (.T.)
> (Default) The CursorAdapter uses transactions when sending Insert, Update or Delete commands through ADO or ODBC.
>
>False (.F.)
> The CursorAdapter doesn't use transactions when sending Insert, Update or Delete commands through ADO or ODBC.
>
>
>And since I do use Transactions through ODBC, why would I need to set this property to .F. ? Unless I misunderstood what you were suggesting.
I've really never used CursorAdapters, but did use SQLEXEC() commands, so I thought that if one must use SqlSetProp() with the parameter "2" to activate maunal transaction, then may be this is the same with CursorAdapters with this property. But I really don't know and just wanted to let you know about it.
Fernando D. Bozzo
Madrid / Spain