User`s guide

1-87
1 to 199
 Without any pattern of occurrence, you may receive a status 85
when the file is closed because Anti-Virus software opens and
locks the file to scan causing the next database operation to fail.
To resolve, set the Anti-Virus software to not scan Pervasive
PSQL data files. Consult your Anti-Virus software manual for
instructions on how to exclude files.
 A delete action was attempted on a data file that is in continuous
operations. A data file put into continuous operations is locked
from deletion through the relational interface and the
transactional interface. In addition, the file is locked from any
attempts to change the file structure, such as modifying keys and
so forth.
86: The file table is full
An application may receive this status code if the database engine is
unable to allocate memory to represent a Btrieve data file. The
database engine also has a limit of 65,535 files that it can handle at
the same time. The status code is also returned if that limit is
reached.
One possible cause of this status code is an application that continues
to open additional files without closing the data files that it has
already opened. View the active files with the Monitor utility to
examine whether this may be happening. See Viewing Active Files in
Advanced Operations Guide.
In addition, consider status code 87: The handle table is full. Status
code 86 is for files and status code 87 is for handles. Multiple handles
can be open for a given file. If the database engine cannot allocate
memory for a Btrieve handle, then the application may receive a
status 87. The handles allocated to client applications are limited by
memory. (Older types of handles that are allocated to DOS
applications using the DOS requesters are limited 65,535.)
87: The handle table is full
This status code is obsolete in Pervasive.SQL 2000i and later
versions. The handle table is managed dynamically by the engine.
You have either attempted to open more handles than the
MicroKernel is configured to support, or the MicroKernel attempted
to open more files than the operating system allows.