Subject Re: [IBO] How to hide transactions to the user. I'm confused
Author Jason Wharton
You don't have them use a transaction bar. Only utility apps for my purposes
have one of those.

But, I do have a base class for which has transaction awareness built into
it and it allows the user to click a button "Ok" (Commit and end), "Cancel"
(Rollback and end) or "Apply" (SavePoint and remain open). I just got
through talking about it. I suggest you give it a look. This is something
users are VERY accustomed to.

In some cases the form closes and goes away or I have it initialize back to
a default state, usually searchmode in a primary tab.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Marco Menardi" <mmenaz@...>
To: <>
Sent: Wednesday, November 14, 2001 4:50 PM
Subject: [IBO] How to hide transactions to the user. I'm confused

> I'm developing a sort of accounting app. For base tables (customers,
> etc.) I'm using a single transaction component for all the queries
> with AutoCommit set to true.
> That works fine for single table work, but when I work on a
> master-detail relation (without referential integrity, and let me
> without it for this discussion) the user can insert the master record,
> fill some fields, insert the detail, fill some fields, post the
> detail, cancel the master!
> I don't want the user to deal with the transaction bar, since it's a
> too advanced topic for such a simple data entry situation.
> So I think I need something like:
> If inserting to master, start transaction
> If posting on master, commit transaction
> If cancelling on master, rollback transaction
> So I can work with the base transaction inside the BeforeInsert,
> AfterPost and AfterCancel qryMain events.
> Is it good this way? How do you do this kind of job?
> Second: if while inserting a master record I call a window for editing
> another table, since both are chained to the same transaction
> component, will be initiated one more transaction, or the two edits
> are inside the same? I ask this because with SQL monitor I usually see
> a lot of different transaction numbers carrying on when I insert
> master+detail, so I'm missing the relation between the transaction
> component and started transactions...
> Thanks
> Marco Menardi