$ERR_INVOPER

627

Invalid operation: operation

An invalid operation has occurred. The following are some examples of invalid operations:

• A collection was modified while a FOREACH statement was being executed.
• An invalid operation occurred during a Select, or the Select did not have a Sparse object.
• You specified a Where clause in the Select that contains a join, with a reference to one of the inner tables. A Where expression can only reference the driving (or outermost) table. To apply a filter condition to an inner table, move it to one of the On expressions.
• An attempt was made to supply both remote and local files to a remote JoinSelect, or a remote file specification specified a server other than the one executing the JoinSelect. It’s not possible for a remote JoinSelect to access files on a machine other than the one it’s running on.
• One of the following was used with GroupBy: SparseUpdate, DeleteCurrent, an RFA, or an IsLocked or GetCTInfo property.
• An invalid situation occurred with a static cursor, including
• A GetCTInfo property or a From object with locks enabled was used with a static cursor. (Instead of a lock, use input mode or Q_NO_LOCK.)
• The static cursor was too small for the Select operation. (Consider increasing static cursor size with the SYNSEL_CURSORMEM environment variable or reducing the amount of data used by the static cursor with Sparse.)
• Records were added to the static cursor that would require expanding the static cursor beyond the current maximum.
• An error occurred during memory allocation.

• The SYNSEL_CURSORMEM environment variable had an invalid value.