Informix Error -50107: An SQL error has occurred in ixSuperTable::doSQLDelete() (err) for the following SQL stmt: "stmt".

Reasons / Common Causes

-50107 is raised by the ixSuperTable class in the Window Painter GUI builder library — per the official guidance:

The SQLDelete() event has been called with the default handler ixSuperTable::doSQLDelete(), but the engine reported an error. A problem might exist with the primary-key specification, or a referential integrity constraint might prevent the deletion. Try looking up the engine error code, which is displayed in parenthesis.

1. An SQL error has occurred in ixSuperTable::doSQLDelete() (err) for the following SQL stmt: "stmt", per the official guidance — the direct, documented condition.

Solutions / Resolution

1. Adjust the calling code to respect the constraint named in the message, per the official guidance — no other resolution is documented.

Examples

N/A

No specific triggering statement is documented beyond the class-library condition described above.

Diagnostic Checks

1. Check the specific value, object state, or call sequence that ixSuperTable flags here, against the constraint the official guidance describes.

Related Errors / Related Topics

• -50136 — "In ixSuperTable constructor, neither updateTable nor selectFromPart has been set for this SuperTable, so requested lock mode is invalid -- defaulting lock mode to noLock." Another ixSuperTable-related condition in this set.
• -50134 — "Cannot retrieve more than 16382 rows into an ixSuperTable on Windows." Another ixSuperTable-related condition in this set.

An SQL error has occurred in ixSuperTable::doSQLDelete() (err) for the following SQL stmt: "stmt".