Number of rows in associated query
Returns the number of rows in the query which provides data for the block. This is the number of rows returned by the database, plus (or minus) subsequent insertions or deletions.
number getQueryRow ( )Get current query row number
Returns the row number (within the rows returned from the database. again plus or minus subsequent insertions or deletions) corresponding to the current row, that is, the row that has focus (in a form) or which is being processed (in a report).
string getRowValue ( string ctrlName, number rowNum )Get value from associated query
This method returns the value for the specified column (identified by the corresponding control name) and row, where the row is the row number amongst the data returned by the database. This will usually be the same as the value displayed in a form (if the record is currently displayed). However, it will be different if the user has edited the displayed value but has not saved the change.
void setRowValue ( string ctrlName, number rowNum, string value )Set value in associated query
The specified value is stored into the specified column (identified by control name) and row in the data returned by the database. Note that this will be overwritten if the user subsequently changes the value displayed in the corresponding control; also, the value will not be saved to the database unless the record is saved.
bool isInQuery ( )See if query (find) is in progress
Returns a true result if the block is executing a query, eg., the user has clicked the start query tool button.
void setUserFilter ( string filter )Server-side only method
Set filter for subsequent queries
Set a filter expression to be used in subsequent queries. This should be a valid SQL where expression, and will be used in the query in addition to any other filtering expressions.
void setUserSorting ( string sorting )Set sorting for subsequent queries
Set an ordering expression to be used in subsequent queries. This should be a valid SQL order by expression, and will be used in the query in addition to (and after) any other ordering expressions.