BorlandTalk.com

Dietmar Brueckmann · Guest

Hi,

in preparing for changing from BDE to dbExpress I write all my new
Applications with TClientDataSet. Very often for readonly SELECT result to
show it in TDBGrids. Thats why my DataModules increases.
So I've written a descendant from TDataSetProvider that creates a T...Query
(Class depends of the connection-type) if no DataSet is specified.
The SELECT-statement is always stored in the TClientDataSet
(provider.poAllowCommandText).
Now I've got a problem, because of a in the SELECT calculated field XYZ.
The generated update-statement contains the this field: --> error.
cdsXYZ.ProviderFlags:=[] doesn't help.
So I've extended my TDataSetProvider-Class that it copies the
cds.fields.providerflags to the fields of the internal created T...Query.

This does it.
But I think there could be a simpler solution - And thats my question!!!

Best regards
Dietmar