Devart Forums

WE are uploading a SQL table to an on-line mysql table and both contain common column BOTH_DESC. The local column in Boolean
and five rows have a value of TRUE. The put column.... statemewnt in Delphi is Sender.putcolumndata('BOTH_DESC', indx,GetBoolean('BOTH_DESC'));

The column in our mysql file was entered as BOOL, but the server changed it to tinyint[1]. The five rows have a value of -1 in the on-line data base. and then a mysql command if(BOTH_DESC=1) is executed,
the test faols.

Why does the mysQL table have -1 as opposed to the expected 1`

Thanks

George

The point is that Delphi converts boolean value True to -1 and not to 1.
Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.