Borland Database Engine (BDE) Classroom Training and Certification Classes

• Access stacks size to 20K.
• Access the number of file holds accessible to the application via the Windows API function SetHandleCount.
• To check the return values of every single BDE function call and deliver some means for handling the outcome of any return value other than DBIERR_NONE.

One possibility is that share might be running out of locks. The command line share will raise the number of files that can be locked and the recall will be available for files.

A folder lock needs to be located within the folder covering the table to prevent the BDE from trying to create a lock file in that folder.

In the BDE configuration utility, you can specify whether the default query mode is SERVER or blank. When you leave the SQL QUERY MODE case blank, the link of SQL will determine which is faster, a local query or a remote query and execute the request accordingly. The situation for SQL QUERY MODE is in the Aliases button in the DBOPEN set of parameters.

Queries will implement locally if the process you are trying is not supported under the SQL standard your SQL server adheres to. If you are attached to InterBase, the remote query you are trying to run must be SQL compliant in order for the query to run remotely. Another you should look out for remote tables that have names in reserved words. This will also root and request to run locally, even however the SQL button gives an SQL translation of the QBE query.