Hi All,
SQLIte, laz 1.8.0RC1, Ubuntu 16.04
Here's what get and it shows the sqlConn (my Connection) as tossing the error, or does it?
Project sData raised exception class 'ESQLDatabaseError' with message: sqlConn: no such column: zDate
procedure TDM.RefreshSerial(aFld, aDir : String);
var
sqlStr : String;
begin
// sqlSerial.Close;
sqlStr:='SELECT * FROM sqlSerial ORDER BY '+aFld+' '+aDir+';';
sqlSerial.SQL.Text:=sqlStr;
sqlSerial.ExecSQL;
// sqlSerial.Open;
end;
If I single step through the code it is showing a correct string,
sqlStr = 'SELECT * FROM sqlSerial ORDER BY zDate ASC'' And, Yes, zDate is a valid Field in the Table.
Thoughts?
Thanks