--- In ib-support@y..., mss@s... wrote:

> I am using IBX components in
> connection with Delphi 5. I am also not using any type
> of "StartTransaction - Commit" type logic.

...

> Any ideas as to what I am doing wrong?
>

Many <g>.

1. Do you have D5 update pack 1 installed? If not,
http://www.borland.com/devsupport/delphi/downloads/index.html
and search one for your edition.

2. Do you have newest IBX component set installed (Borland
ships very old and buggy one with D5)? If not,
http://www.borland.com/devsupport/interbase/ibx_updates.html
and search IBX 4.52 Update for Delphi 5

3. Any operations on any SQL server are performed in transaction's
context. If you don't explicitly handle them, Delphi components
do it for your, but in this case you rely on how "artificial
intellegence" understand your purposes. IBX starts "default
transaction", that is specifyed in IBDataBase component and
commits it when you leave application. While this transaction
is active, no one other application (if to be more correct,
transaction) can see changes that made within it. So, until
you read Programmers Guide "Working with transactions", I
shall speak a language that is completely foreign to you,
as you said Jason. To see your IBX transaction parameters,
double-click your TIBTransaction component. IBX transaction
management is lowest level, very close to IB API level, BDE -
most higher level (and most deceptive and slow), mr. Wharton's
IBO have both low-level and middle, more evident to novice.


Good luck.