Page 1 of 1
sqlite datetime parameter
Posted: Wed Jan 30, 2019 1:01 pm
by 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
Re: sqlite datetime parameter
Posted: Thu Jan 31, 2019 7:06 am
by Lech Kulikowski
Hello,
Please send us your report for analysis.
Thank you.
Re: sqlite datetime parameter
Posted: Thu Jan 31, 2019 7:12 pm
by akatsifos
and the test.db is only one table as
CREATE TABLE [t1](
[s1] VARCHAR2(100),
[i1] INT,
[d1] DATE);
Re: sqlite datetime parameter
Posted: Mon Feb 04, 2019 8:51 pm
by Lech Kulikowski
Hello,
We need some time to investigate the issue.
Thank you.
Re: sqlite datetime parameter
Posted: Mon Mar 18, 2019 8:25 am
by akatsifos
any actions ?
regards
Re: sqlite datetime parameter
Posted: Tue Mar 19, 2019 3:21 pm
by 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.
Re: sqlite datetime parameter
Posted: Fri Apr 12, 2019 3:34 pm
by akatsifos
any chance to give me fix date or plan to new report tool?
regards
Re: sqlite datetime parameter
Posted: Sat Apr 13, 2019 12:28 pm
by Lech Kulikowski
Hello,
We are still working on that problem. We will try to fix it in the next release build.
Thank you.
Re: sqlite datetime parameter
Posted: Wed May 22, 2019 6:24 pm
by akatsifos
2019.3.1 still getting same error !!!
Re: sqlite datetime parameter
Posted: Fri May 24, 2019 10:58 am
by HighAley
Hello.
Sorry for the issue.
We will check everything again and let you know about results.
Thank you.
Ticket reference: #177