Foxpro Error: Operation is invalid for a Memo, Blob, General or Picture field.

Error: Operation is invalid for a Memo, Blob, General or Picture field
Message: Foxcode table not found, is not correct version or is incompatible.
METHOD: beforeopentables
PROGRAM: frmCheckerCreateUser


There may be following reasons for above error

1) An INDEX command cannot specify a Memo or Blob field as its key expression.

2) There was not enough memory (shared pool) for Visual FoxPro to complete an operation.

3) Unions between differing column types are not allowed when one of the columns is of Memo or General type unless UNION ALL is used.

4) Visual FoxPro cannot update the specified cursor because it is read-only. This can occur when attempting to write to a file created or accessed for read-only purposes.


Solution;

CURSOR_SHARING (Default value: Exact): Share the plan only if text of SQL matches exactly with the text of SQL lying in shared pool.

Sqlplus>show parameter cursor_sharing

Exact is the default value for cursor_sharing.

Sqlplus>ALTER SYSTEM SET cursor_sharing='EXACT';

-- verify default value of EXACT
Sqlplus>show parameter cursor_sharing

-- clear all cached SQL statements
Sqlplus>ALTER SYSTEM FLUSH SHARED_POOL;
Sqlplus>ALTER SYSTEM FLUSH SHARED_POOL;