I generated an Entities unit for an SQLITE database using Data Modeler. All the fields defined as Booleans by sqlite were exported as Strings by TMS Data Modeler. This is causing an error because what is actually in the field is an integer with 0 = False and 1 = True. I could go through and redefi…

Data Modeler translate booleans

GOMEZEL_DINO (GOMEZEL DINO) March 31, 2022, 8:06am 7

But I'm searching for a way to have Delphi boolean and MySQL Field that is TinyInt and has 0 or 1 as velue.

Topic		Replies	Views
Mysql, boolean values and TinyIntFormat TMS Aurelius	1	587	October 3, 2021
SQLite boolean field TMS Aurelius	1	65	July 18, 2024
Firedac MySQL boolean fields TMS WEB Core	1	894	August 20, 2019
Bit type data fields - gives error message TMS XData	12	1382	September 20, 2018
SQL Error: Incorrect integer value: 'Y' for column `users`.`ACTIVE` at row 1. TMS Aurelius	8	262	March 17, 2023