VFP 愛用者社區

[walter_yang]

小弟有二個問題想請教，在VFP + SQL 2000下用ADO建立CA的資料環境下VFP如何調用SQL Server中已經寫好的Store Procedure，另外使用CA時該如何手動控制Transaction，可否提供簡單的程式碼做參考！謝謝

[syntech]

一般使用SQL Server後端資料庫,
會使用手動方式進入交易模式,
如果你沒有作手動方式進入交易模式,
預設就是每個table自己單獨進交易模式.

還有,我記得Begin Transaction......End Transaction只對table有效,
對遠端無效

[syntech]

from MSDN

------------------
Visual FoxPro 9.0
How to: Control Transactions Manually

If you want to control transactions manually, you can set the Transactions property to 2, or DB_TRANSMANUAL. With manual transaction handling, Visual FoxPro automatically begins a transaction for you when you issue the first data-writing SQL statement, but you must submit the Visual FoxPro SQLCOMMIT( ) or SQLROLLBACK( ) functions to end the transaction. For the CursorAdapter object, you can set the UseTransactions property to false (.F.) and the CursorAdapter does not use transactions to send Insert, Update, or Delete commands.

To use manual transaction mode
Use the DBSETPROP( ) Function to set the Transactions property on the connection to 2 or DB_TRANSMANUAL.

-or-

Use the SQLSETPROP( ) Function to set the Transactions property on the active connection to 2 or DB_TRANSMANUAL.

Transaction processing is handled manually through SQLCOMMIT( ) FunctionSQLCOMMIT( ) Functionand SQLROLLBACK( ) Function.

After committing or rolling back the prior transaction, Visual FoxPro automatically begins a new transaction when you issue the next data-writing SQL statement. For more information about transactions, see Programming for Shared Access.

Visual FoxPro supports transactions nested up to five levels for local data. A single level of transaction support is built into SQL pass-through.

If your server supports multiple levels of transactions, you can use SQL pass-through to manage transaction levels explicitly. Explicit transaction management is complex, however, because it can be difficult to control the interaction between the built-in transaction and the timing of remote server transactions. For more information on explicit transaction management, see your ODBC documentation.

[syntech]

所以依MSDN內容來看,
就是先把 CursorAdapter.UseTransactions 設為 .F.,
然後依 SPT 的方式操作.

[syntech]

"Begin Transaction......End Transaction只對table有效, 對遠端無效 "

MSDN 說,對CursorAdapter仍然有效,但是我沒有測試.