View Incident Report

Serious

Reported By: Michael Fry
Reported On: 5/3/2002
For: Version 3.10 Build 1

# 1126 Executing an SQL Script that Ends with an SQL SELECT Causes Error on Remote Server

I have an error coming up when executing the following remote SQL script. This worked until DBSRVR V. 3.10 and still works with local tables.

DROP TABLE IF EXISTS MEMORY "MEM_TABLE";
SELECT * INTO MEMORY "MEM_TABLE" FROM PHY_TABLE;

Comments

You must update both the client and server engines to 3.11 in order to fix this problem.

Resolution

Fixed Problem on 5/4/2002 in version 3.11 build 1

More Support Options