Hi,

having defined memory database I want to create in memory table using

CREATE TABLE SAMETABLE (LIKE DISKBASE.SOURCETABLE)

In database DISKBASE the table SOURCETABLE exists but I get the error
'ElevateDB Error #401 The table SOURCETABLE does not exist'.

Does LIKE clause not permit qualification?

Iztok Lajovic
KreS, Kreativni sistemi

>
> having defined memory database I want to create in memory table using
>
> CREATE TABLE SAMETABLE (LIKE DISKBASE.SOURCETABLE)
>
> In database DISKBASE the table SOURCETABLE exists but I get the error
> 'ElevateDB Error #401 The table SOURCETABLE does not exist'.
>
> Does LIKE clause not permit qualification?
>
> Iztok Lajovic
> KreS, Kreativni sistemi


I found the solution of the problem:

CREATE TABLE SAMETABLE AS SELECT * FROM SOURCETABLE WITH NO DATA

What is intention of LIKE statement or the difference between LIKE clause
and this select statement at least?

Iztok Lajovic

Iztok,

<< having defined memory database I want to create in memory table using

CREATE TABLE SAMETABLE (LIKE DISKBASE.SOURCETABLE)

In database DISKBASE the table SOURCETABLE exists but I get the error
'ElevateDB Error #401 The table SOURCETABLE does not exist'.

Does LIKE clause not permit qualification? >>

It may not.  If so, I'll make sure that this is corrected since it shuld be
possible.

--
Tim Young
Elevate Software
www.elevatesoft.com