Reported By: Robert Gesswein Reported On: 6/12/2004 For: Version 4.08 Build 1
# 1765Adding a Primary Index On a Table With a Missing .IDX File Causes AV When I try to rebuild the primary key on a table with no defined primary key i receive an access violation. Same thing when just opening the table and letting the system try to rebuild the primary key.
To see this (using DBSys):
1. Create the following table.
CREATE TABLE Bleem
FIELD1 VARCHAR(20) NOT NULL
2. Unprepare the query.
3. Delete the Bleem.idx file.
4. Run the following query to rebuild the needed primary key:
ALTER TABLE Bleem ADD PRIMARY KEY (RecordID)
You will see an access violation error.
ResolutionFixed Problem on 6/12/2004 in version 4.09 build 1