sqlite .AsDateTime error cannot access field as type DateTime

[irwanto]

hi help me,


when i use .AsDateTime get error "cannot access field as type DateTime"
here my code :

Code: Select all

 FConnection_SQLITE.Database := IncludeTrailingPathDelimiter(ExtractFilePath(ParamStr(0))) + 'smart_sfa.db3';
  FConnection_SQLITE.Connect;

  FQueryUniv.Close;
  FQueryUniv.SQL.Text := 'select max(tgl) as tgl, nm_hari from tblclosing left outer join tblhari on (strftime(''%w'', tblclosing.tgl)+1 = tblhari.kd_hari)';
  FQueryUniv.Open;

  if FQueryUniv.RecordCount <= 0 then
  begin
    raise Exception.Create('Tanggal transaksi di table closing kosong');
  end;

  ShowMessage(FQueryUniv.FieldByName('tgl').AsString);
  ShowMessage(DateToStr(FQueryUniv.FieldByName('tgl').AsDateTime)); /// <======== error here

SQLITE Direct Mode

Delphi XE5
UNIDAC 6.1.3
Windows 8.1

file test
http://www.filedropper.com/zzzz

[AlexP]

Hello,

If you are using concatenation, aggregating functions (MAX, AVG, ...), etc., SQLite returns the Unknown type for such fields. For correct data display, you should use DataTypeMapping https://www.devart.com/unidac/docs/#dat ... apping.htm .

[irwanto]

thanks,,
working...

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.