Option Form, To“ on Select
I discover “from to” option on “select” function :
on Customer table ([“Young”,“Roggers”,“Thomas”,“Grey”,“Marcus”,“Wilson”,“Wood”,“Williams”,“Smith”,“Cooper”]) you can select juste part of records :(select Customer from 1 to 4).“Last name” return [“Roggers”,“Thomas”,“Grey”]
Return records form 1 to 3 of Customer table.
syntax : select [table] /where / from [first record number begin by 0] to [last record number not include] / order by
It seems options are run one after one. In first “where”, “from, to” and then “order by”.
(select Customer where “Last name” like “w” from 0 to 2).“Last name” return [“Wilson”,“Wood”]
Return the 2 first records of three returned by where.
(select Customer from 0 to 3).“Last name” return [“Young”,“Roggers”,“Thomas”]
Return three first records of table order by alphabetic “Last name”.
Some one know more about it ?
2 replies
-
Hello Jaques.
select Table from NUM1 to NUM2
NUM1 = Start record (First record starts at 0)
NUM2 = Number of records to be displayed. -
No, it seem work like Range function : range(From, To), From in inclusive and To is exclusive.
(see Loop here : https://ninox.com/en/manual/calculations/reference-of-functions-and-language)
If I try with (select Customer from 2 to 4).“Last name”, result is [“Thomas”,“Grey”] records 2 and 3 of Customer table
Content aside
- 3 yrs agoLast active
- 2Replies
- 480Views