>>>hi,
>>>You didnt understand what i was saying,
>>>
>>>SQLSETPROP(oApp.oVar.sqlHandler,"Transactions",DB_TRANSMANUAL)
>>>Would need SQlcommit() and sqlrollback() to be effictive
>>>
>>>Would SQLEXEC(handle,"Commit Transaction") alone be more than sufficient ?
>>>
>>>Try it with the codes i posted.
>>>
>>>thanx,
>>>Suhashegde
>>>
>>>P.S.: Just saw that you were using both. Both start at the same place and end at the smae place. No updates are sent to server in between them. So sqlsetprop would be a unnecessary call. And Also would increment @@Trancount unnecessarily
>>
>>No updates, ha?
>>:-)
>>Sorry, I can't resist.
>>You didn't use Buffering. So By Deafult the cursor uses RowBuffering. When you chnage Record pointer the record IS updated.Try this:
>>

>>lccon = [DRIVER=SQL Server Native Client 10.0;Server=nagaveni\sql2008;Trusted_Connection=Yes]
>>han = SQLSTRINGCONNECT(lccon)
>>
>>SQLEXEC(han,"create table #foo (f1 int,f2 char(20))")
>>SQLEXEC(han,"select * from #foo ",'foo')
>>CURSORSETPROP([Buffering], 5, [Foo])
>>
>>CURSORSETPROP("Tables","#foo","foo")
>>CURSORSETPROP("UpdateNameList", "f1 #foo.f1, f2 #foo.f2")
>>CURSORSETPROP("KeyFieldList", "F1")
>>CURSORSETPROP("UpdatableFieldList", "f1,f2")
>>CURSORSETPROP("SendUpdates", .T.)
>>
>>FOR m.xi = 65 TO 90
>>   INSERT INTO foo VALUES (m.xi,REPLICATE(CHR(m.xi),10))
>>ENDFOR
>>
>>SQLSETPROP(han,"Transactions",2)
>>SQLEXEC(han,"BEGIN TRANSACTION")
>>
>>IF TABLEUPDATE(.t.,.t.,"foo",fooerror)
>>   Messagebox("records with Begin transaction and SQLSETprop transaction")
>>   SQLEXEC(han,"select * from #foo ",'foo1')
>>   brow
>>
>>   SQLSETPROP(han,"Transactions",1)
>>   Messagebox("records with Begin transaction ")
>>   SQLEXEC(han,"select * from #foo ",'foo1')
>>   brow
>>
>>   SQLEXEC(han,"ROLLBACK TRANSACTION")
>>   Messagebox("records with ROLLBACK TRANSACTION")
>>   SQLEXEC(han,"select * from #foo ",'foo1') && EMPTY result
>>   brow
>>ELSE
>>   DISPLAY MEMORY LIKE fooerror
>>ENDIF
>>

>
>I have bufferring set to 5 default and didnt post that hoped you will understand.
>
>Ya, Thats what i am saying no updates.SQLSETPROP(han,"Transactions") has no effect. Then why use ? It will be effective only with SQlcommit() or Sqlrollback()
>
>try this
>
>

>lccon = [DRIVER=SQL Server Native Client 10.0;Server=nagaveni\sql2008;Trusted_Connection=Yes]
>han = SQLSTRINGCONNECT(lccon)
>
>SQLEXEC(han,"create table #foo (f1 int,f2 char(20))")
>SQLEXEC(han,"select * from #foo ",'foo')
>CURSORSETPROP([Buffering], 5, [Foo])
>
>CURSORSETPROP("Tables","#foo","foo")
>CURSORSETPROP("UpdateNameList", "f1 #foo.f1, f2 #foo.f2")
>CURSORSETPROP("KeyFieldList", "F1")
>CURSORSETPROP("UpdatableFieldList", "f1,f2")
>CURSORSETPROP("SendUpdates", .T.)
>
>FOR m.xi = 65 TO 90
>   INSERT INTO foo VALUES (m.xi,REPLICATE(CHR(m.xi),10))
>ENDFOR
>
>SQLSETPROP(han,"Transactions",2)
>SQLEXEC(han,"BEGIN TRANSACTION")
>
>
>IF TABLEUPDATE(.t.,.t.,"foo",fooerror)
>
>   Messagebox("records with Begin transaction and SQLSETprop transaction")
>   SQLEXEC(han,"select * from #foo ",'foo1')
>   brow
>
>   SQLCOMMIT(han)                                 && encountered commit here
>   Messagebox("records after SQL commit ")
>   SQLEXEC(han,"select * from #foo ",'foo1')
>   brow
>
>   SQLSETPROP(han,"Transactions",1)
>   Messagebox("records after SQlsetprop to automatic ")
>   SQLEXEC(han,"select * from #foo ",'foo1')
>   brow
>
>* now will this be rolled back ? No
>   SQLEXEC(han,"ROLLBACK TRANSACTION")
>   Messagebox("records  after ROLLBACK TRANSACTION")
>   SQLEXEC(han,"select * from #foo ",'foo1')
>   brow
>
>ELSE
>   DISPLAY MEMORY LIKE fooerror
>ENDIF
>
>
>

>
>suhashegde


Suhas,
If you run SQL Profiler you will see that there is NO difference what you use. I prefer to use SQLEXEC(xxxx,[ROLLBACK TRANSACTION]) or SQLEXEC(xxx,[COMMIT])
You could use SQLCOMMIT(han) or SQLROLLBACK(han)