No results in queries

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Francisco
Posts: 5
Joined: Thu 06 Jun 2013 20:17

No results in queries

Post by Francisco » Thu 06 Jun 2013 20:43

Hello,
I'm using V.2.0.1 for RAD Studio XE4, in Firemonkey for MAC OSX, and here component TLiteQuery:
SELECT * from ... is working, but the following queries do not have any results:

SELECT COUNT (*) FROM ... 0 => Result is always NULL (empty value, not "0")

SELECT avg (somefield) as ... from => Result is always 0
SELECT MAX (somefield) as... from => Result is always 0
and last but not least "last_insert_rowid" is not working, too.
Can anyone help me, please?
Thanks in advance

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: No results in queries

Post by AlexP » Fri 07 Jun 2013 08:17

hello,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: No results in queries

Post by AlexP » Fri 07 Jun 2013 09:13

Hello,

We have already fixed this problem, please send us your license number and e-mail to alexp*devart*com in order for me to send you the fixed version of LiteDAC. Also, please specify your version of the IDE.

Francisco
Posts: 5
Joined: Thu 06 Jun 2013 20:17

Re: No results in queries

Post by Francisco » Fri 07 Jun 2013 11:43

Cool! Thank you! :-)
Regards

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: No results in queries

Post by AlexP » Fri 07 Jun 2013 14:30

Hello,

I have sent you a fixed LiteDAC Std version for RAD Studio XE4

Francisco
Posts: 5
Joined: Thu 06 Jun 2013 20:17

Re: No results in queries

Post by Francisco » Fri 07 Jun 2013 14:50

Hello, now it works fine! Thank you!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: No results in queries

Post by AlexP » Fri 07 Jun 2013 15:04

Hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

Post Reply