Re: TRANSACTION

>I'm programming with VB5 under NT. I use an Workstation Server 7.23. If >I start a >Transaction - make updates, inserts and so on and kill the >program/workstation or network connection so there is no commit-command >was sent to the server. > >All updates, inserts and deletes are in the database! This can't be >normal? You might be suffering from the dreaded implied commit. If the sqlhandle is reused and the previous event was not rolled back it is committed. Let's see, assuming all is fine, writing data regardless of validity, yup, sounds downright microsoftish. Gatesism - noun: The pursuit of poor workmanship and mediocrity as desirable goals.