>>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.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham