View Incident Report

Minor

Reported By: Robert Gesswein
Reported On: 6/12/2004
For: Version 4.08 Build 1

# 1765 Adding 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.

Resolution

Fixed Problem on 6/12/2004 in version 4.09 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap