sqlite datetime parameter

Stimulsoft Reports.Net discussion
Post Reply
akatsifos
Posts: 5
Joined: Wed Jan 30, 2019 12:56 pm

sqlite datetime parameter

Post by akatsifos » Wed Jan 30, 2019 1:01 pm

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
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: sqlite datetime parameter

Post by Lech Kulikowski » Thu Jan 31, 2019 7:06 am

Hello,

Please send us your report for analysis.

Thank you.
akatsifos
Posts: 5
Joined: Wed Jan 30, 2019 12:56 pm

Re: sqlite datetime parameter

Post by akatsifos » Thu Jan 31, 2019 7:12 pm

and the test.db is only one table as
CREATE TABLE [t1](
[s1] VARCHAR2(100),
[i1] INT,
[d1] DATE);
Attachments
Datetime_sqlite.mrt
(8.63 KiB) Downloaded 18 times
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: sqlite datetime parameter

Post by Lech Kulikowski » Mon Feb 04, 2019 8:51 pm

Hello,

We need some time to investigate the issue.

Thank you.
akatsifos
Posts: 5
Joined: Wed Jan 30, 2019 12:56 pm

Re: sqlite datetime parameter

Post by akatsifos » Mon Mar 18, 2019 8:25 am

any actions ?
regards
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: sqlite datetime parameter

Post by Lech Kulikowski » Tue Mar 19, 2019 3:21 pm

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
Posts: 5
Joined: Wed Jan 30, 2019 12:56 pm

Re: sqlite datetime parameter

Post by akatsifos » Fri Apr 12, 2019 3:34 pm

any chance to give me fix date or plan to new report tool?
regards
Lech Kulikowski
Posts: 1871
Joined: Tue Mar 20, 2018 5:34 am

Re: sqlite datetime parameter

Post by Lech Kulikowski » Sat Apr 13, 2019 12:28 pm

Hello,

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

Thank you.
akatsifos
Posts: 5
Joined: Wed Jan 30, 2019 12:56 pm

Re: sqlite datetime parameter

Post by akatsifos » Wed May 22, 2019 6:24 pm

2019.3.1 still getting same error !!!
HighAley
Posts: 8065
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: sqlite datetime parameter

Post by HighAley » Fri May 24, 2019 10:58 am

Hello.

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

Thank you.

Ticket reference: #177
Post Reply