Re: [Gambas-user] Conversion of datacheckbox control value from text to integer

2015-07-16 Thread Randall Morgan
Yes, -1 for True and 0 for false. I would bet that the conversion from access changed boolean fields to string fields. I would add a column for boolean values and then insert the values based on the contents of the string field. Then drop the string fields and rename the boolean columns. Then I th

[Gambas-user] Conversion of datacheckbox control value from text to integer

2015-07-16 Thread Martin McGlensey
Good Morning, I have a MySQL database containing data moved from Access. There are four checkbox fields containing text data (TRUE or FALSE). In my Gambas app these fields are contained in a datasource that supplies data to four datacheckbox controls. The app throws an error "Wanted integer but