I am migrating my application from Firebird to SQLite. One of the necessary changes is that database columns of type VARCHAR in Firebird are of type TEXT in SQLite, so that persistent fields corresponding to such columns need to be changed from TStringField to TMemoField. I do this by pulling up the Fields Editor in the Laz IDE (double-click on the TSQLQuery component on the form), delete the old field, then use Add Fields to create it again with the same name and as if by magic the new type. But here's the problem : I edited the SQL property in the TSQLQuery component, and the Fields Editor is ignoring the edited SQL. The list of fields available to add is taken from the old SQL, even though the edited SQL no longer selects those columns, and columns added to the selection in the new SQL are omitted/ignored. Laz appears to have got its knickers in a twist, has anyone else suffered this? The SQL SELECT includes a LEFT OUTER JOIN, and the fields pulled in from the joined table were early casualties, as if the join itself triggered something?
Any help/views would be much appreciated, before I delete the TSQLQuery component and redo from scratch.
