Delphi 4 C/S - TClientDataSet

Hi,

I have a three tier application that uses the TClient DataSet component.  If
the ClientDataSet's datasource is a query that consists of only one table,
the application works fine.  But if the query consists of two tables with a
join, the ClientDataSet thinks it has updated but the main database has not
been updated.  In Delphi 3 I used to use the USQLProvider component, but
that is not supplied in Delphi 4.

Many Thanks

Phil Shrimpton