On 01/12/16 16:15, Martin Collins via Lazarus wrote: > From what I understand, SQLite TEXT type has no set length so db aware > components treat it as a memo. Therefore when I assign a TEXT field to a > db aware component, all that appears in the component is "(MEMO)", even > though most of my TEXT fields are only up to 10-30 characters long. > Solutions offered on-line suggest using a dbmemo (which I have for my > longer TEXT fields as that's what I want), but I need to use dbgrids, > dbedits, dbcomboboxs, etc for the shorter TEXT fields. > I have found a solution to my problem, with thanks to the following link:
http://www.tweaking4all.com/software-development/lazarus-development/lazarus-pascal-getting-started-with-sqlite/#ATEXTfieldshowsamemoinaDBGrid The answer was altering my SQL Query text, from something like this: SELECT "Filename", "Date" FROM "mytable"; to this: SELECT CAST( "Filename" AS VARCHAR) AS "Filename", "Date" FROM "mytable"; Casting it as a different type in the SQL statement worked! My bad and inexperience with databases! Hope this will help someone else one day! :-) Thanks & best regards, Martin -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus-ide.org http://lists.lazarus-ide.org/listinfo/lazarus
