View Incident Report

Serious

Reported By: Roy Lambert
Reported On: 3/10/2007
For: Version 1.02 Build 1

# 2306 Deleting All Rows From a Table Using DELETE Statement Can Cause #601 Error

Prior to renaming a field I used your utility to export the data. Did the necessary messing around to drop and add the field. Then did a DELETE FROM table to the data with the now blank new field and used import facility.

I was rewarded by error 601, the index page is empty.

IMPORT TABLE "Transactions"
FROM 'E:\MyM\New Folder\Transactions.csv'
DELIMITER CHAR ','
QUOTE CHAR '"'
DATE FORMAT 'yyyy-mm-dd'
TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM'
DECIMAL CHAR '.'
BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False'
USE HEADERS
MAX ROWS -1

Resolution

Fixed Problem on 3/18/2007 in version 1.03 build 1

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap