sqlite datetime parameter

[akatsifos]

Hello
I am using an sqlite datasource and a select statemnt like
select * from mytable where datetime_field=:1
add a paramter :1 type datetime
and add a variiable d1 as datetime request from user
and in :1 parameter in expresion the name of my variable d1
when i ry to run it it says unable to convert form datetime to int32

Any actions Regards
Aris

[Lech Kulikowski]

Hello,

Please send us your report for analysis.

Thank you.

[akatsifos]

and the test.db is only one table as
CREATE TABLE [t1](
[s1] VARCHAR2(100),
[i1] INT,
[d1] DATE);

[Lech Kulikowski]

Hello,

We need some time to investigate the issue.

Thank you.

[akatsifos]

any actions ?
regards

[Lech Kulikowski]

Hello,

We work hard on this problem and do our best to do it as fast as possible. We will let you know when the solution is available.

Thank you.

[akatsifos]

any chance to give me fix date or plan to new report tool?
regards

[Lech Kulikowski]

Hello,

We are still working on that problem. We will try to fix it in the next release build.

Thank you.

[akatsifos]

2019.3.1 still getting same error !!!

[HighAley]

Hello.

Sorry for the issue.
We will check everything again and let you know about results.

Thank you.

Ticket reference: #177