General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only