OK, perhaps secrets is too strong of a word, but when went to the servoy magazine today I noticed that the controller.loadAllRecords() can have a SQL statement as the parameter!!! Is this anywhere in the doc or am I blind? (I do wear glasses!). In the same article from riccardo, I also see the syntax for searching a range of dates.
invoice_date = startdate + “…” + enddate + "|dd-MM-yyyy
So my question is, what do I have to do to learn / find these tricks???
thanks
bruce
sorry, never did learn to read and type at the same time
blomasky:
OK, perhaps secrets is too strong of a word, but when
went to the servoy magazine today I noticed that the controller.loadAllRecords()
can have a SQL statement as the parameter!!!
Is this anywhere in the doc or am I blind? (I do wear glasses!)…
Bruce,
Information on the function that you refer to - controller.loadRecords(sqlstring) -
can be found in several places:
-
Servoy Developer Edition Volume 2: Reference Guide - in printed book
format that contains every Servoy function along with a description and
example(s) and can be purchased from the Servoy Store.
-
Servoy Developer Reference Guide - downloadable pdf.
-
Servoy online Help Navigator - online Help in Servoy Developer that
can be opened by Choosing Help>Help or pressing F1.
NOTE: If you have installed a full version of Servoy 2.2, you may need to
download the online Help documentation file first. And if you are updating
from an earlier (already installed) version of Servoy, then open the
Servoy/docs/developer_manual, select all the files and delete them - DO
NOT delete the developer_manual folder itself. The next time that you
choose Help>Help or press F1 in Servoy Developer, you will see the
download dialog displayed.
Marc Norman
Servoy
Thanks. Have the manuals, but did not notice that loadRecords() was polymorphic. Saw the first defin. with no parameters and skipped to the next method. WILL READ SLOWER FROM NOW ON!
thanks
bruce