Hello Tim,
  Is "CREATE TABLE LIKE" gonna be supported in the future ?

Thank you

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Charalabos


I think the functionality is already in there - check out the CREATE TABLE help

Roy Lambert

Hello Roy,

> I think the functionality is already in there - check out the CREATE
> TABLE help

Well it gives an error message:
SQL: CREATE TABLE "run2" LIKE "run"
Error: Format '%s' invalid or incompatible with argument

Didn't find it on the manual either. I think it's part of SQL:2003 too.

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

M,

<< Well it gives an error message:
SQL: CREATE TABLE "run2" LIKE "run"
Error: Format '%s' invalid or incompatible with argument >>

CREATE TABLE "run2" ( LIKE "run" )

Ole Willy Tuv

Hello Ole,

> CREATE TABLE "run2" ( LIKE "run" )
>
> Ole Willy Tuv

Thanks worked.

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< Well it gives an error message:
SQL: CREATE TABLE "run2" LIKE "run"
Error: Format '%s' invalid or incompatible with argument >>

Are you using the Unicode version ?  I think there's an issue with the
Format function in that version that needs correcting.

<< Didn't find it on the manual either. I think it's part of SQL:2003 too.
>>

It's right here:

http://www.elevatesoft.com/edb1sql_create_table.htm

See the <LikeDefinition> portion.   LIKE can be used multiple times, and in
conjunction with existing columns, so it is included within the parentheses.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

> It's right here:
>
> http://www.elevatesoft.com/edb1sql_create_table.htm
>
> See the <LikeDefinition> portion.   LIKE can be used multiple times,
> and in conjunction with existing columns, so it is included within
> the parentheses.

Oh boy. I searched the "ElevateDB Version 1 Manual" and not
the SQL manual. That's why i found nothing!

Thanks Tim!

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Michael,

<< Oh boy. I searched the "ElevateDB Version 1 Manual" and not the SQL
manual. That's why i found nothing! >>

Yes, we split up a lot of information that used to be in the one manual in
DBISAM in order to separate the compiler-specific information from the
general product information.

--
Tim Young
Elevate Software
www.elevatesoft.com