Icon View Incident Report

Serious Serious
Reported By: Frank Fischer
Reported On: 4/25/2006
For: Version 4.22 Build 3
# 2183 Using the System RecordID Twice in a Live Query Causes Error 10000 Invalid Field Definition

Using the RecordID of a table the following way causes the error:

"DBISAM Engine Error # 10000 Invalid field definition specified for the field 'ID' in the table 'MyTable' "

SELECT RecordID AS ID, RecordID AS ID2 FROM MyTable



Resolution Resolution
Fixed Problem on 4/25/2006 in version 4.24 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image