Relational writeback
To write back to a relational data source, you can use RWDB, DBEXECUTE, and
DBEXECUTEFIXED formulas. The relational list must be writable.
Note: DBEXECUTE is supported only in
on-premises environments and in Inforcommercial
applications in cloud environments. In custom or extended applications you can use
DBEXECUTE or DBEXECUTEFIXED.
You write back in View mode.
RWDB and DBEXECUTE support special key commands to delete values from a relational data source. The behavior of the commands depends on the datatype of the column on which the command is executed.
| Command | Writes Back: | |
|---|---|---|
| Character Datatype | Numerical Datatype | |
| DEL | "" (empty string) | 0 |
| CTRL+DEL | Null | Null |
| BACKSPACE | "" (empty string) | Has no effect |
| CTRL+BACKSPACE | "" (empty string) | Has no effect |