refresh_block

refresh_block function has 2 variants:

Variant 1

Declaration

void refresh_block(char blockName);

Description

refresh_block function does sequentially:

1. Needs datablock tag in form file.

2. Prepares and executes data block's query.

3. Executes "post_query" trigger for each row.

4. 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');

Variant 2

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);