I having problems with sqlite3 saving fields date time, I define as date the field but i insert fields not message error all look good but when i open table all date fields are empty, is first time that happen to me, i try also insert with parameters all fields but still the same.... some ide what why that happen
while not DBF1.EOF do begin
SQLs.SQL.Text:='insert into lvacc (adate , adt , exc , auto, ckbit ) values(:pdate, :padt,:pexc , :pauto ,:pckbit )';
SQLs.ParamByName('pdate').AsString:= FormatDateTime('yyyy/mm/dd', Dbf1.FieldByName('adate').AsDateTime );
SQLs.ParamByName('padt').AsString := FormatDateTime('yyyy/mm/dd', Dbf1.FieldByName('adt').AsDateTime ) ;
SQLs.ParamByName('pexc').AsString := Dbf1.FieldByName('exc').AsString;
SQLs.ParamByName('pauto').AsString := Dbf1.FieldByName('auto').AsString ;
SQLs.ParamByName('pckbit').AsString:= Dbf1.FieldByName('ckbit').AsString ;
SQLs.ExecSQL;
DBF1.Next;
end;
thanks.
Fernando