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