General information
Title:
SQL Property - Transaction
I have a Oracle Package that would return an error unless I set the transaction property to 2. I have a similar package that does not return the crytic error (driver out of resources) in either mode 1 or 2. The fix is obvious (maybe), set the transaction to 2 and move on. But I just need to know - why? Both packages are simply returning cursors back to VFP of selected data. Any ideas? If you need more detail, email me. Thanks.
"Transactions Contains a numeric value that determines how the connection manages transactions on the remote table. Transactions may assume the following values:
1 or DB_TRANSAUTO (from FOXPRO.H).
1 is the default. Transaction processing for the remote table is automatically handled.
2 or DB_TRANSMANUAL (from FOXPRO.H). Transaction processing is handled manually through SQLCOMMIT( ) and SQLROLLBACK( ).
Read-Write."
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