Borland®
Shop
Products Downloads Services Support Partners News & Events Company Community

Updates & Patches
AppCenter
AppServer
Borland C++
BDE
Borland Enterprise Server
C++Builder
CodeWright
Delphi
InterBase
Janeva
JBuilder
JDataStore
Kylix
Optimizeit
Pascal
Security Service
VisiBroker

Community Site
AppServer
C++
CORBA
Delphi
InterBase
Java
Linux
Search
Advanced Search

 BDE/SQL DEVSUPPORT

Borland Database Engine/SQL Links 5.01
Enhancements and Fixes

ACCESS SECTION


Areas of concentration under: access


Area: access

Reference Number: 10 (Published: 01/13/98)
Status: Fixed
Sub Area: Cursor Maintenance
Date Reported: 07/15/97
Severity: Critical
Type: Basic Functionality Failure

Problem:

Multi-Select on a DBGrid connected to any Access 
Table generates recurring error:
"No current record. Table."

Only way out is to end task.

Area: access

Reference Number: 18 (Published: 11/12/97)
Status: Fixed
Sub Area: Data Access
Date Reported: 08/20/97
Severity: Commonly Encountered
Type: Basic Functionality Failure

Problem:

In some instances, DbiGetRecordForKey and 
DbiSetToKey, return 'No Record Found' on a partial 
match, alpha-numeric field.  Seems like a language 
driver problem.

Area: access

Reference Number: 3 (Published: 01/13/98)
Status: Fixed
Sub Area: Referential Integrity
Date Reported: 06/16/97
Severity: Infrequently Encountered
Type: Basic Functionality Failure

Problem:

Attempting to add/modify records (via 
DbiInsertRecord, DbiModifyRecord) to a detail table 
that has a referential integrity link to a master table, 
but does not have linking values to the master, 
results in [51][3] (Unknown SQL error) rather than 
[38][5] (Master record missing / 
ERRCODE_FORIEGNKEYERR).

(Fyi, this fails for most SQL drivers - Acc, Inf, Int, 
Mss, Ora, Syb - but works for DB2.) - (Has now 
been fixed for all Sql drivers)

Area: access

Reference Number: 7 (Published: 11/12/97)
Status: Fixed
Sub Area: Data Access
Date Reported: 06/30/97
Severity: Infrequently Encountered
Type: Basic Functionality Failure

Problem:

Trying to access an AutoIncrement or Number field 
with a sub-type of ReplicationID (GUID) returns 
error 'Capability Not Supported'.

BTW: The MSAccess ODBC driver opens this field 
type as VARBYTES.

Area: access

Reference Number: 2 (Published: 01/13/98)
Status: Fixed
Sub Area: FieldMap
Date Reported: 02/28/97
Severity: Infrequently Encountered
Type: Minor Functionality Failure

Problem:

If a fieldmap is placed on a table, DbiClonedCursor() 
returns DBIERR_NIY;

Area: access

Reference Number: 9 (Published: 01/13/98)
Status: Fixed
Sub Area: Stored Procedure
Date Reported: 07/11/97
Severity: Infrequently Encountered
Type: Minor Functionality Failure

Problem:

DbiOpenSPParamList doesn't show types for 
bPhys=false

Example:
Place a TStoredProc in delphi.
Set database and procname.
For parameters... see that param names show up 
but without types.

Area: access

Reference Number: 14 (Published: 11/12/97)
Status: Fixed
Sub Area: Environmental
Date Reported: 07/23/97
Severity: Infrequently Encountered
Type: Minor Functionality Failure

Problem:

For accessing the DAO registry entries  it is not 
necessary to use the samDESIRED option of 
KEY_ALL_ACCESS.  Since we are only reading the 
registry entry, using KEY_QUERY_VALUE 
(Preferrably) or KEY_READ is only necessary.

A problem with users that set their registry to read 
only occurs when trying to load the DAO, 
RegOpenKeyEx fails and the BDE returns 'Cannot 
Load IDAPI Service Library'

Area: access

Reference Number: 25 (Published: 11/12/97)
Status: Fixed
Sub Area: Translation
Date Reported: 09/05/97
Severity: Infrequently Encountered
Type: Minor Functionality Failure

Problem:

DbiTranslateRecordStructure and DbiTranslateField 
when going to a Paradox Alphanumeric to 
MSACCESS creates a CHAR field. A better match 
to a Alphanumeric field would be a MSACCESS 
VARCHAR field.

Area: access

Reference Number: 1 (Published: 01/13/98)
Status: Fixed
Sub Area: FieldMap
Date Reported: 02/28/97
Severity: Extremely Rare Case
Type: Minor Functionality Failure

Problem:

DbiSetFieldMap() returns Operation not Applicable 
error if iFields > # of fields in table.



NOTE: These listings are for informational use only. It is not intended for use when calling Borland's Developer Support Department.
If you have any suggestions or complaints about these 'BDE Enhancements and Fixes' pages, please contact the BDE Administrator. This e-mail address is not intended for support issues.

 
Site Map Search Contact