Re: [SQL] Moving around in a SQL database

2006-04-20 Thread Florian Reiser
use fetch to get the desired row. After you are finished use CLOSE to close it. With kind regards Florian Reiser -- http://www.ra-bc.de RA Unternehmensberatung Führen durch präzise Daten "WillemF" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] >I am a nov

Re: [SQL] Moving around in a SQL database

2006-04-21 Thread Florian Reiser
update statements. After that do a COMMIT TRANSACTION. If anything fails between BEGIN and COMMIT TRANSACTION all changes will be reverted to the state before the transaction. With kind regards Mit freundlichen Grüssen Florian Reiser -- http://www.ra-bc.de RA Unternehmensberatung Führen durch