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 got string". I assume that means that the expression datacheckbbox1 = rstData!box1 returns a string when the datacheckbox is looking for an integer. Is this correct? I Is it -1 for true and 0 for false? If so what is the best way to correct this? Should I change the data from string to integer? Not so easy as it is a big table; lots of chance for error there. Should I convert the data to the proper value using a function (on Change) when the field is accessed or changed? Looking for the best way to do this with minimal risk to the data. Thank you for your help. All responses are appreciated. Regards, Marty ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user