Query.SQL.Text := 'SELECT COALESCE(COUNT(ID),0) as count from main where used_where=0 and sold_where IN (3,6);';
Query.Active:=True;
if Query.BOF and Query.EOF
then Memo.Lines.Append('No records.')
else Memo.Lines.Append('Count : '+ Query.FieldByName('count').AsString);
Memo.Lines.Clear;
Query.Refresh;
Query.SQL.Text := 'SELECT COALESCE(COUNT(ID),0) as count, curtime() as ct from main where used_where=0 and sold_where IN (3,6);';Now at every 10 seconds clock shows actual time but count does not changes.
Query.Active:=True;
if Query.BOF and Query.EOF
then Memo.Lines.Append('No records.')
else Memo.Lines.Append('Count : '+ Query.FieldByName('count').AsString+
' , ' + Query.FieldByName('ct').AsString);
SELECT COALESCE(COUNT(ID),0) as count FROM mainand this works as expected (Edit: Not in all cases. ??? Not refreshes when grows and refreshes when decreases ???).
WHERE now() < addtime(used_datetime,''00:40:00'');
I did some tests and now switching to ZEOSDBO.