SQLite Forum

cannot create tables in sqlitestudio than other apps can see
Login
Problem solved !!!!!
The solution was for me to use the 32 bit sqlite3.dll in Delphi's bin folder, but to use the 64 bit sqlite3.dll in the folder containing the .EXE file.

The only remaining problem is the text fields appear in the dbgrid as "MEMO" or (WIDEMEMO". Integer fields show in the grid correctly.

My workaround is to use a tmemo component and add sqlquery1.fieldbyname(fieldname').asstring;

I have seen solutions offered suggesting to have the sql cast (myfield as varchar) but that did not work. 

Still, I am happy the data can be retried.

I am grateful for all people who have responded.