refresh_block
refresh_block function has 2 variants:
Declaration
void refresh_block(char blockName);Description
refresh_block function does sequentially:
Needs datablock tag in form file.
Prepares and executes data block's query.
Executes "post_query" trigger for each row.
Sends the new content of the data block to the client.
Parameters
char blockName
Return Value
Example
Reads all rows from database and shows them in data block.
refresh_block('emps');Declaration
void refresh_block(char blockName, char whereClause);Description
Same as Variant 1 except this version filter database rows stated in whereClause condition
Parameters
char blockName
char whereClause
Return Value
Example
Reads filtered data from database and shows them in data block.
refresh_block('emps', 'department_id = ' || :Session.UserDepartmentId);Last updated
Was this helpful?