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. For example, extend a hyperblock to create additional value cells and insert a function into each.

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 these 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.