Icon View Incident Report

Minor Minor
Reported By: Stephan Markwalder
Reported On: 1/12/2004
For: Version 4.01 Build 1
# 1526 Manual Does Not Specifically Point Out That SQL SELECT INTO Clause Overwrites Specified Table

I was not aware, that the "SELECT xx1, xx2 INTO TABLEyy... is actually (re-)creating TABLEyy, without any indexes. I called EmptyTable just before I called my SQL SELECT statement with the INTO clause.

The manual could be a little bit preciser in regard to the creation of the result table.

Resolution Resolution
Fixed Problem on 1/12/2004 in version 4.02 build 1