transaction - rollback in C ???
-
hi everybody. now, i wish help for me this matter. when I update field "Pass" of table USER. if table USER have 10 records, but when update to records 5 ==> error, i need rollback all data when table not update, but if update 10 records success ==> update all. thanks very much.
nothing
-
hi everybody. now, i wish help for me this matter. when I update field "Pass" of table USER. if table USER have 10 records, but when update to records 5 ==> error, i need rollback all data when table not update, but if update 10 records success ==> update all. thanks very much.
nothing
You posted no code (you even did'n mention the database you are dealing with): how can we help you?
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
hi everybody. now, i wish help for me this matter. when I update field "Pass" of table USER. if table USER have 10 records, but when update to records 5 ==> error, i need rollback all data when table not update, but if update 10 records success ==> update all. thanks very much.
nothing
-
Rollbacks should be supported by the database. So in C you should start a "transaction" which could get rolled back.
Press F1 for help or google it. Greetings from Germany
-
this matter need application of VC++6.0 support, because SQL Server not support. sql server only support transaction 1 record. in C# it support this application by Transaction, but in VC++6.0 I don't know. wish your help. thanks very much
nothing
aa_zz wrote:
because SQL Server not support. sql server only support transaction 1 record.
I bet my 2 cents the above sentence is false. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
this matter need application of VC++6.0 support, because SQL Server not support. sql server only support transaction 1 record. in C# it support this application by Transaction, but in VC++6.0 I don't know. wish your help. thanks very much
nothing
are we in the same sql server: http://msdn.microsoft.com/en-us/library/ms188929.aspx[^] here a plenty of possibilities: http://social.msdn.microsoft.com/Search/en-US?query=sql%20server%20c%2B%2B&ac=3[^] :mad:
Press F1 for help or google it. Greetings from Germany
-
aa_zz wrote:
because SQL Server not support. sql server only support transaction 1 record.
I bet my 2 cents the above sentence is false. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
i agree with you. but if you using plus string, it can update more records, but it will overload string :^) .
nothing
aa_zz wrote:
but if you using plus string, it can update more records, but it will overload string
I don't get you. :confused:
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
are we in the same sql server: http://msdn.microsoft.com/en-us/library/ms188929.aspx[^] here a plenty of possibilities: http://social.msdn.microsoft.com/Search/en-US?query=sql%20server%20c%2B%2B&ac=3[^] :mad:
Press F1 for help or google it. Greetings from Germany
i think, we can using "registry" to do it, but i don't using it. for examble :http://www.codeproject.com/KB/vista/VistaKTM.aspx nothing
-
i think, we can using "registry" to do it, but i don't using it. for examble :http://www.codeproject.com/KB/vista/VistaKTM.aspx nothing