set_block_property(‘NOMEDOBLOCO’, DEFAULT_WHERE, ‘ID = :usuario.ID’);
Exemplos de propriedades que podem ser modificadas:
* DEFAULT_WHERE;
* ORDER_BY;
* ALL_RECORDS;
* BLOCKSCROLLBAR_POSITION;
* BLOCKSCROLLBAR_X_POS;
* BLOCKSCROLLBAR_Y_POS;
* COORDINATION_STATUS;
* CURRENT_RECORD_ATTRIBUTE;
* CURRENT_ROW_BACKGROUND_COLOR;
* CURRENT_ROW_FILL_PATTERN;
* CURRENT_ROW_FONT_NAME;
* CURRENT_ROW_FONT_SIZE;
* CURRENT_ROW_FONT_SPACING;
* CURRENT_ROW_FONT_STYLE;
* CURRENT_ROW_FONT_WEIGHT;
* CURRENT_ROW_FOREGROUND_COLOR;
* CURRENT_ROW_WHITE_ON_BLACK;
* DELETE_ALLOWED;
* DML_DATA_TARGET_NAME;
* ENFORCE_PRIMARY_KEY;
* INSERT_ALLOWED;
* KEY_MODE;
* LOCKING_MODE;
* MAX_QUERY_TIME;
* MAX_RECORDS_FETCHED;
* NAVIGATION_STYLE;
* NEXT_NAVIGATION_BLOCK;
* OPTIMIZER_HINT;
* PRECOMPUTE_SUMMARIES;
* PREVIOUS_NAVIGATION_BLOCK;
* QUERY_ALLOWED;
* QUERY_DATA_SOURCE_NAME;
* QUERY_HIT;
* UPDATE_ALLOWED;
* UPDATE_CHANGED_COLUMNS;
* etc.