can anyone confirm/deny if the TOP function should work in the InlineQuerier, as in...
Select TOP 10 * from table1
I am having no joy so far
thanks
can anyone confirm/deny if the TOP function should work in the InlineQuerier, as in...
Select TOP 10 * from table1
I am having no joy so far
thanks
Best answer by takashi
The InlieQuerier uses SQLite database internally, and SQLite doesn't support "TOP" clause. You can use "LIMIT"" instead.
-----
select * from table1 limit 10
Takashi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.