XE5 SQLite TEXT Data shows as WideMemo

[Robert Baker]

I tried using W2S and Delphi Edit controls as custom but so far unsuccessful

Data is the same except respective types: MS SQL [nVarChar] / SQLite [TEXT]

How can I get my SQLite text to properly display [e.g. property{s}?

Thanks -rb-

[Robert Baker]

One additional note -my data displays properly using Delphi's std. string grid.

[Roy Woll]

Hi Robert,

It seems that you have created a database for sqlite of all blob/memo fields instead of regular varchar fields.  Is there a reason your database is structured in this way. By doing this, you will have limited functionality such as not being able to sort, search, or filter.

Instead of using Text for your Sqlite database, why  not just create the fields as varchar(25) or something like that (in this way its like your MSSQL database)  You can create string fields in this way.  I think the trick is that the default design tools don't show varchar, but if you click the ... icon in the SQLite database browser, you can type something like varchar(25) there and the field will then be a TStringField. Then you can sort, search, just like a normal database. You won't need to keep jumping through hoops to make your database act like others.

Note, you may need to remove all the fields at design time and add them back in (or else delphi will still the old tmemofield types in its dataset. This can be done by dbl-clicking the dataset and removing all the tfields.

I'm no expert on SQLite, so you may want to visit some of their newsgroups/support to find out more information on this database format.

-Roy