On Mar 22, 2005, at 7:26 AM, Szmutku Zolt�n wrote:
Hi everybody ,
�
I try using Postgre, but �I have some problems.
I create a constraint (� R1>=0 ), and after connect to server from VFP via ODBC .
In the client program I turn on the transactions . (� SQLSETPROP(nHandle,'Transactions',2)�� )
�
When I run UPDATE statements one after the other , and one return false because of constraint ,
then the server rolling back all changing automatically.
I would like to: server ignore�the bad statements (return false)�and after I call rollback or commit manually....possible ?
Within a transaction, if one statement fails, all changes will be rolled back. If you want to commit each statement that works, you can commit (or rollback) after each statement.
Sean
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
