UpdateDatabase SQLite all TEXT

BIZ TMS Aurelius
1

Hi, when I use UpdateDatabase with SQLite it create all table fields as TEXT type.

2

Please provide detailed info. We just can't tell what is wrong. What are the steps to reproduce? What is your mapping and current state of database? What is the SQL generated by Aurelius?


Also be aware that SQLite doesn't have strong types in database so having all fields as TEXT type won't do much harm anyway.

3

I had to create a custom generator to solve this problem...
into "DefineColumnType" method I added this switch in case statement:

    ftString:
      Column.DataType := 'VARCHAR(' + IntToStr(Column.Length) + ')';