sqlite datetime parameter
sqlite datetime parameter
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
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
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: sqlite datetime parameter
Hello,
Please send us your report for analysis.
Thank you.
Please send us your report for analysis.
Thank you.
Re: sqlite datetime parameter
and the test.db is only one table as
CREATE TABLE [t1](
[s1] VARCHAR2(100),
[i1] INT,
[d1] DATE);
CREATE TABLE [t1](
[s1] VARCHAR2(100),
[i1] INT,
[d1] DATE);
- Attachments
-
- Datetime_sqlite.mrt
- (8.63 KiB) Downloaded 115 times
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: sqlite datetime parameter
Hello,
We need some time to investigate the issue.
Thank you.
We need some time to investigate the issue.
Thank you.
Re: sqlite datetime parameter
any actions ?
regards
regards
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: sqlite datetime parameter
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.
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
any chance to give me fix date or plan to new report tool?
regards
regards
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: sqlite datetime parameter
Hello,
We are still working on that problem. We will try to fix it in the next release build.
Thank you.
We are still working on that problem. We will try to fix it in the next release build.
Thank you.
Re: sqlite datetime parameter
2019.3.1 still getting same error !!!
Re: sqlite datetime parameter
Hello.
Sorry for the issue.
We will check everything again and let you know about results.
Thank you.
Ticket reference: #177
Sorry for the issue.
We will check everything again and let you know about results.
Thank you.
Ticket reference: #177