I'm seeing inconsistencies in the TDBGrid based on the SQLite data type. The attached program will create a table with three fields with the fields being one of the following data types:
- VarChar(2000)
- Text(2000)
- Text
- WideChar
The following is the behavior for each type:
VarChar(2000):
Everything works as it should.
Text(2000)
If "Insert Data Upon Creation" is checked, no data is shown when the table is created.
Upon posting a new row, you get EXC_BAD_ACCESS.
Upon putting data in a column in a new row, and then moving to a new column, you get EXC_BAD_ACCESS.
Text
Exactly the same as Text(2000)
WideChar
If "Insert Data Upon Creation" is checked - the test data is shown when the table is created as with VarChar(2000).
Upon posting a new row, you get EXC_BAD_ACCESS.
My database utilizes WideChar and this used to work without issue in Lazraus 1.8. It also works fine in Delphi 7 and in Objective-C on iOS.
Can anyone tell me how make it work with the other data types I list?
Thank you,
Eric