mysql versione 5.0
delphi version 7.0 built 8.1
driver version 3.0.1.0
when i call applyupdates method return this error:
'unknown column xxxx in where clause'
source:
object SQLConnection1: TSQLConnection
ConnectionName = 'MySQL (Core Lab)'
DriverName = 'MySQL (Core Lab)'
GetDriverFunc = 'getSQLDriverMySQL'
LibraryName = 'dbexpmda.dll'
LoginPrompt = False
Params.Strings = (
'BlobSize=-1'
'HostName=127.0.0.1'
'DataBase=commi'
'DriverName=MySQL (Core Lab)'
'User_Name=root'
'Password=01071966'
'FetchAll=True'
'EnableBoolean=False')
VendorLib = 'libmysql.dll'
Connected = True
Left = 32
Top = 16
end
object SQLDataSet1: TSQLDataSet
CommandText =
'select * from `tab_3`, `tab_4`'#13#10'where codice=cod'#13#10'order by dat' +
'a desc'
MaxBlobSize = -1
Params =
SQLConnection = SQLConnection1
Left = 112
Top = 16
end
object DataSetProvider1: TDataSetProvider
DataSet = SQLDataSet1
Left = 192
Top = 16
end
object ClientDataSet1: TClientDataSet
Aggregates =
Params =
ProviderName = 'DataSetProvider1'
Left = 280
Top = 16
end
object DataSource1: TDataSource
DataSet = ClientDataSet1
Left = 352
Top = 16
end
thanks for your help.
don't work with multiple query
INSERT, UPDATE, DELETE statements are generated by ClientDataSet but not our driver. So we ask you to test your application using standard driver. If problem disappears using standard driver please send (dbxmda*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.