Skip to main content
  • EN
Hi All,

 

 

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
Hi,

 

 

The InlieQuerier uses SQLite database internally, and SQLite doesn't support "TOP" clause. You can use "LIMIT"" instead.

 

-----

 

select * from table1 limit 10

 

 

Takashi
Thanks Takasahi, thats what I needed...

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.