refresh_block function has 2 variants:
refresh_block
void refresh_block(char blockName);
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.
char blockName
Reads all rows from database and shows them in data block.
refresh_block('emps');
void refresh_block(char blockName, char whereClause);
Same as Variant 1 except this version filter database rows stated in whereClause condition
whereClause
char whereClause
Reads filtered data from database and shows them in data block.
refresh_block('emps', 'department_id = ' || :Session.UserDepartmentId);
Last updated 5 years ago