> My very simple test program works fine when running with the
> commercial version of Interbase 6.0 that came with Delphi. The
> program fails only when the new Firebird 1.0 server is running
> (actually, it also failed with Firebird Release Candidate 2). I'm not
> sure that many Delphi people would know which (if any) subtle
> differences between Interbase and Firebird need to be accounted for
> in Delphi programs.

I would have to ask "Does it work with 6.5?"

> > As above. Refresh closes and reopens the dataset. RefreshRecord
> > needs to have a successful CommitRetaining within a READ COMMITTED
> > transaction; but it looks as if the Commit(retaining) is failing
> > because of missing keys.
>
> The transaction is set to READ COMMITED. Initially the Delphi
> dbExpress database connection component was set at its default of
> CommitRetaining=False; I changed to CommitRetaining=True and re-ran
> the program with no success. As before, the program worked fine with
> the Interbase 6.0 server but failed with the Firebird 1.0 server.

Not using IBX, it's difficult to suggest anything here

> I'm a newbie to Interbase, Firebird, and Delphi. From what you are
> telling me, it sounds as though I would need to be an advanced user
> to get help from this list.

All Henel is really asking is "What SQL are you using?".
From the example is sounds simple, but we may miss
additional Properties that need to be set for IBX.

> I had hoped that perhaps some Interbase/Firebird afficionado might
> have Delphi and be tempted to spend two minutes creating a simple
> dbExpress application with a RefreshRecord operation and tell me if
> they also receive errors with the Firebird Server (either RC2 or
> v1.0).

Unfortunatlly most of us 'afficionado's' stopped using IBX
some time ago, there is an IBX list, but I am not sure if
they will bother with Firebird questions <g>

> > Highly likely, considering your test code appears to do nothing to
> > try to identify what is going on, e.g.
> > Showmessage(MyQuery.Sql.Text) in your BeforePost event would
> > probably be quite revealing.
>
> I'm not sure that the "ShowMessage(MyQuery.Sql.Text)" pertains to
> dbExpress with SQLDataSet -> Provider -> SQLClientDataSet ->
> DataSource. At any rate, if I knew how to do this (or its dbExpress
> equivalent) I would gladly do it.

Three teir database access?
There MUST be a Query definition somewhere in the chain in
which you specify the SQL for the Query?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services