Reported By: Stephan Markwalder Reported On: 1/12/2004 For: Version 4.01 Build 1
# 1526Manual 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.
ResolutionFixed Problem on 1/12/2004 in version 4.02 build 1