|
























|
 |
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.
|
|