Lester,

> Unfortunatlly most of us 'afficionado's' stopped using IBX
> some time ago

so much time that you don't even seem to recognise it from dbExpress.
:-)

Paul,

> > 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.

Forget it. Put in a SQLMonitor (see help for details) and see the exact
SQL statements that get sent to the server, then post them here and
we'll see what is wrong with them.
I can assure you that I am able to refresh single records with dbX, but
sometimes you need to fiddle with the source dataset fields'
ProviderFlags, that are used to build the refresh statement in a
somewhat convoluted manner (the fault, if there is one, is in
TDataSetProvider rather than TClientDataSet or dbX).
HTH
--
____
_/\/ando