LargeInt fields show up as TStringField in Table component

[nostradumbass]

After right click on field collection editor in table component and select 'Add all fields', if there is a LargeInt field, it gets added as a String field.

Is this a bug in ZeosDBO that it is not reading the table structure properly?

[mdaems]

This might be becuse of the 'loose typing' used by SQLite.
Actually, except for some execptions, SQLite ignores the field type you define. So it's difficult for zeoslib to guess the correct datatype.

Have a look at ConvertSQLiteTypeToSQLType to see how conversion is done.

Mark

[pcoenen]

Hi,

Using ZeosLib Trunk version 774, Delphi 2010, SQLite Databse

After right click on field collection editor in table component and select 'Add all fields', if there is a LargeInt field, it gets added as a String field.

Same problem here but I have a INT64(LARGEINT) in the database that gets added as a TIntegerField.

Any idea?

Pascal

[pcoenen]

My own fault

I recreated the table and used BIGINT when I created the field in the table. Now I have a TLargeIntField in the field editor.

Great

[mdaems]

Pascal,

Did you find the solution by studying the type conversion rules used by zeoslib? When 'yes', can I convince you to write an article about it in the Sqlite section of the Knowledge Base?

Mark