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
Solved
Inline Querier fails on SQL TOP function
Hi All,
Best answer by takashi
Hi,
View original
The InlieQuerier uses SQLite database internally, and SQLite doesn't support "TOP" clause. You can use "LIMIT"" instead.
-----
select * from table1 limit 10
Takashi
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.