Savepoints, Rollbacks in forms
Posted on 1999-01-14
I issue an insert into statement and before comitting I issue a clear_block(no_validate) to cancel the transaction, but the insert statement is not rolled back. When I issue a rollback the command will delete my headings(title, datetime, userid etc.) off of the form. I have tried using a savepoint that I set just after I set up my headings on the form and isssue the rollback to savepoint, but it still does not seem to work. Can I rollback my insert into statement without clearing out my complete form?