Devart Forums

create Table1 (amount decimal(16,5) default 0)

i use query data via sql command :
'select sum(amount) sumamount from Table1'

TsqlDataset<-TDatasetProvider<-TClientDataset
i add field name 'sumamount' to TClientDataset fieldeditor

Program Old dbxpress driver is work but i test crlab dbxpress driver
it show message error :
'Type mismatch for field 'sumamoun' , expecting :Float actual : FMTBCDField'

Thank for any idea
Tim

Please specify what do you mean under the "Old dbxpress driver" - is it standard Borland driver or an old version of DbxMda?
Probably you have created a field(s) of the TFloatField type with the driver you name "Old", and then switched to the new DbxMda. Try to recreate with the new DbxMda driver all the fields created in design time before swithing.