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: In cloud environments, DBEXECUTE
is supported only in Infor commercial applications.
You cannot use DBEXECUTE in custom or extended applications. Instead, use
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 |