Reported By: Roy Lambert Reported On: 3/24/2007 For: Version 1.01 Build 1
# 2285Database Name Qualifiers Being Allowed in CREATE TABLE Statements After executing the following SQL, I have a TEDBTable pointing at RecList with the database set to RAM and I get an error when trying to open the table
401 the table or view RecList does not exist
CREATE TABLE RAM.RecList AS
(SELECT *
FROM Transactions
WHERE
_Reconciled = False
AND
_fkAccounts = :Account)
WITH DATA
CommentsThe problem is that EDB was ignoring the database qualifier and not raising an error when it was used.
ResolutionFixed Problem on 3/25/2007 in version 1.02 build 1
Products AffectedElevateDB 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