No results in queries
Posted: 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
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