Informix Error -3452
Cause and resolution
Add, Update and Remove operations not allowed on a remote table.
The table that is being queried is in a database that is external to the current database (the one that is named in the DATABASE section of the form). Such tables cannot be modified. (This message is not currently used. You might encounter it with products of Version 4.0 or earlier.)
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-3452 fires when Add/Update/Remove is attempted on a table external to the form's own database — per the official guidance, such remote tables can't be modified through a form; the guidance also notes this message is not currently used and might only be encountered with Version 4.0 or earlier products.
- The queried table belongs to a database external to the one named in the form's
DATABASEsection, per the official guidance — the direct cause. - Running a Version 4.0 or earlier product, per the official guidance — the version context in which this message might still appear.
Solutions / Resolution
- Modify the remote table through a means other than this form (e.g. directly via SQL against its own database), per the official guidance, since remote tables can't be Added/Updated/Removed through this mechanism.
Examples
Modifying the remote table directly instead
DATABASE remote_db;
UPDATE orders SET status = 'Shipped' WHERE order_id = 1001;
Diagnostic Checks
- Check whether the table being modified belongs to a database other than the form's own, and modify it through a connection to its own database instead.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -3452 in this set yet.
The table being modified is external to the form's own database — remote tables can't be Added/Updated/Removed through the form; modify them directly instead.