Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 2/4/2001
For: Version 2.06 Build 1
# 714 DELETE and INSERT SQL Statements Causing Error with COMMIT INTERVAL Clause

The following syntax gives an # 11949 SQL error.

DELETE FROM MyTable
COMMIT INTERVAL 250

INSERT INTO BTable
(ID, SField1, SField2)
SELECT ID, SField1, SField2
FROM ATable
COMMIT INTERVAL 500



Resolution Resolution
Fixed Problem on 2/5/2001 in version 2.07 build 1
Image