don't work with multiple query

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
tonitobia
Posts: 1
Joined: Wed 05 Apr 2006 21:49

don't work with multiple query

Post by tonitobia » Wed 05 Apr 2006 21:59

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.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 06 Apr 2006 12:48

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.

Post Reply