Michael,

"Michael Fung " schrieb:

>
> Thanks Luc,
>
> Though I am just inserting to one table, the triggers in that table
> will update other tables. In that case, should I use rollback?

The triggers will only fire when you write that record to the database,
so if you CANCEL a record it won't be posted to the database, thus no
trigger's firing at all.

You have to distingish between client actions (as for example setting a
TIB_Query to INSERT oder EDIT mode) and server actions (which will just
take place when the client tries to post the record (i.e. issue the
insert / update statement to the server)).

So you can still COMMIT the transaction after cancelling your
Insert/Edit mode. The triggers will not fire in either case.

Regards
Luc.