RWDB
When you display a relational list in a hyperblock, only the first column of data is displayed. With the RDB and RWDB functions you can display two or more columns.
Use RWDB to write the values back to the database. You must remove cell protection from the cell that is to be written to and the relational list must be writable.
The RWDB function supports four key combinations with which you can write 0, Null or an empty string to the database:
- DEL - writes 0
- CTRL+DEL - writes Null
- BACKSPACE - writes an empty string ("")
- CTRL+BACKSPACE - writes an empty string ("")
Syntax
= RWDB(HYPERBLOCK("hyperblock name"),row index,column name)If you enter the RWDB function in the value cell of the hyperblock,
you can use the cell reference of the key output cell as the row index. The
hyperblock then lists both columns of data.
Example
= RWDB(HYPERBLOCK("hyperblock1"),B3,"ProductName")
You can use the RWDB function outside a hyperblock cell. Use the
number of a row in the relational list as the row index.
Note: In Design Mode, the result of the RWDB formula is displayed as
#VALUE!. In View Mode the result is correctly displayed.