bool DELETE(bool runTrigger = true, bool scriptHandleException = false); example: Customer:DELETE(); Use this function to delete a record. bool DELETEALL(bool runTrigger = true, bool scriptHandleException = false); example: Customer:DELETEALL(); Use this function to delete...
bool MODIFY(bool runTrigger = true, bool scriptHandleException = false); example: Customer:MODIFY(); Use this function to modify the record. bool MODIFYALL(string FieldName, object newValue, bool runTrigger = true, bool scriptHandleException = false); example: Customer:MODIFYALL(‘Name’, ‘Testdata’,...
bool INSERT(bool runTrigger = true, bool scriptHandleException = false); example: Customer:INSERT(); Customer:INSERT(false); Use this function to inserts a new record. runTrigger defines whether to run the local mobile app trigger, and by default, whether...
The following functions allow you to create, edit and delete records.
int FILTERGROUP(int newGroupNo); exapmle: Customer:FILTERGROUP(1); Customer:SETRANGE(‘Blocked’, false); Customer:FILTERGROUP(0); This function allows you to configure a FilterGroup by adding extra filters that are not directly visible or customizable by the user in lists. Ensure that...
void RESET(); Use this function to delete the current filter.
bool ASCENDING(bool SetAscending); This function is used to sort the current record to ascending, if is set to true and descending if is set to false.
void SETCURRENTKEY(Fieldname1, Fieldname2, Fieldname3, …); Sets key for sorting of the current record. The key used here must be available in the corresponding Microsoft Dynamics table.
int Record:COUNT(); Returns the number of records with the current filters being applied.
bool GET(Fieldname1,Fieldname2,Fieldname3,…); Get a record identified by the primary keys defined. Pleas note, that the -function will not throw an error message, therefor please use the function as following: if not GET(‘CODE’) then ERROR(‘Error...