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
No results in queries
Re: No results in queries
hello,
Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.
Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.
Re: No results in queries
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.
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.
Re: No results in queries
Cool! Thank you! 
Regards

Regards
Re: No results in queries
Hello,
I have sent you a fixed LiteDAC Std version for RAD Studio XE4
I have sent you a fixed LiteDAC Std version for RAD Studio XE4
Re: No results in queries
Hello, now it works fine! Thank you!
Re: No results in queries
Hello,
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.