Locate on DateTime field table
Locate on DateTime field table
Hello,
my Locate on a DateTime field fail, I gess due to some kind of format...
I write the records assigning value to the field .asDateTime and content result is '04/08/18 16:18:02'.
If I read back records in TDateTime variable I get back the same format.
But any Locate using a TDateTime variable as argument, fails.
If I convert that variable in a string, using DateTimeToStr() the Locate are successful...
Is it correct ? any idea on make it work directly with TDateTime values ?
Regards,
Mark
my Locate on a DateTime field fail, I gess due to some kind of format...
I write the records assigning value to the field .asDateTime and content result is '04/08/18 16:18:02'.
If I read back records in TDateTime variable I get back the same format.
But any Locate using a TDateTime variable as argument, fails.
If I convert that variable in a string, using DateTimeToStr() the Locate are successful...
Is it correct ? any idea on make it work directly with TDateTime values ?
Regards,
Mark
Re: Locate on DateTime field table
We tested SQLite work according to your description and found no problems. To investigate the issue, please compose and send us a small test sample, execution of which causes the issue. In addition, we will need a file with SQlite database used in this sample. This database should contain a table with the data that you use in the described case.
For this, it is convenient to use the e-support form (https://www.devart.com/company/contactform.html)
For this, it is convenient to use the e-support form (https://www.devart.com/company/contactform.html)
Re: Locate on DateTime field table
Hello,
after further investigation seems that TLiteTable record read
return only partial value of DATETIME fields of a table;
the milliseconds part is absent or always 000.
It happens even setting
and
I was fooled because until Close table, any read back of records, give me the correct value including milliseconds.
But after table Close and Reopen, in all the records read, the msec part is absent...
I have posted a demo prj in the e-support form.
Regards
after further investigation seems that TLiteTable record read
return only partial value of DATETIME fields of a table;
the milliseconds part is absent or always 000.
It happens even setting
Code: Select all
SqLiteConnection.options.timeformat := 'hh:mm:ss.zzz';
Code: Select all
Formatsettings.LongTimeFormat := 'hh:mm:ss.zzz';
But after table Close and Reopen, in all the records read, the msec part is absent...
I have posted a demo prj in the e-support form.
Regards
Re: Locate on DateTime field table
Thank you for the information. We will investigate the described issue and let you know the results shortly.
Re: Locate on DateTime field table
Hi, any news ?
in my app I need retrieve records with msec granularity...
in my app I need retrieve records with msec granularity...
Re: Locate on DateTime field table
We fixed the bug with getting the value of milliseconds of the DITETIME type fields. The fix will be included in the next build of our product, which we are planning to release next week.
Re: Locate on DateTime field table
Fantastic !
Thank you very much.
Thank you very much.
Re: Locate on DateTime field table
New build of LiteDAC 3.3 including the required changes is already available. A full list of changes is available by the link :
https://www.devart.com/litedac/revision_history.html
https://www.devart.com/litedac/revision_history.html