I need to find out how many records of type X I have in the database.
Since select count(*) is not supported , I was thinking of using something like
SELECT count(distinct(XXX)) from YYY (xxx are unique values)
Is it possible to assign the returned result to a variable and how.
DB Get only seems to be able to get columns values.