I have a table with a byte column - MySQL TINIYINT(3).
When I set up a field on a mask with that table as its datasource, the field is rendered as a checkbox, not a text box containing an integer. Also, in the p4aTable displaying the records in the table, the column contents for the TINYINT(3) field are displaying "no". ( The database has various nonzero byte values.)
Any ideas? How do I get a byte field to be handled as a numeric instead of a checkbox?
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a table with a byte column - MySQL TINIYINT(3).
When I set up a field on a mask with that table as its datasource, the field is rendered as a checkbox, not a text box containing an integer. Also, in the p4aTable displaying the records in the table, the column contents for the TINYINT(3) field are displaying "no". ( The database has various nonzero byte values.)
Any ideas? How do I get a byte field to be handled as a numeric instead of a checkbox?
Thanks!
just do $dbsource->fields->fieldname->setType("integer");
right after the dbsource load() (before mask->setSource())
bye!
fabrizio