Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 8 of 8 total |
CREATE TABLE LIKE ? |
Sat, Aug 11 2007 4:57 PM | Permanent Link |
Charalabos Michael | Hello Tim,
Is "CREATE TABLE LIKE" gonna be supported in the future ? Thank you -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Sun, Aug 12 2007 10:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Charalabos
I think the functionality is already in there - check out the CREATE TABLE help Roy Lambert |
Sun, Aug 12 2007 7:38 PM | Permanent Link |
Charalabos Michael | 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 |
Mon, Aug 13 2007 4:57 AM | Permanent Link |
"Ole Willy Tuv" | 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 |
Mon, Aug 13 2007 4:12 PM | Permanent Link |
Charalabos Michael | Hello Ole,
> CREATE TABLE "run2" ( LIKE "run" ) > > Ole Willy Tuv Thanks worked. -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Mon, Aug 13 2007 4:29 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Mon, Aug 13 2007 4:36 PM | Permanent Link |
Charalabos Michael | 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 |
Tue, Aug 14 2007 5:01 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |