Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread "Show Script" in Alter Table
Sat, Mar 1 2008 3:20 PMPermanent Link

Ralf Graap
Hey Tim,

can we have a "Show Script"-Button or something like this in the
Alter-Table-Dialog.

Sometimes i cant alter a tbale because of an error like this:

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #700 An error was found in the statement at line 3 and
column 6 (Expected BETWEEN, LIKE, IN but instead found NULL)
---------------------------
OK
---------------------------

It would be nice to have a look at this statement.

Thx
  Ralf
Mon, Mar 3 2008 6:26 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ralf,

<< can we have a "Show Script"-Button or something like this in the
Alter-Table-Dialog.

Sometimes i cant alter a tbale because of an error like this: >>

How did the error occur ?  Are you specifying a DEFAULT or CHECK expression
?  Normally there won't be any errors because the SQL is all generated by
the EDB Manager.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Mar 3 2008 3:03 PMPermanent Link

Ralf Graap
Hey Tim,

I'am just playing Smile

CREATE TABLE "Test"
(
"UID" GUID COLLATE "ANSI" NOT NULL
)

- Now Call "Alter Table" Page Columns,
- Click on "Generated",
- Generate as expresion = "current_guid"
- Click on "Alter Column"
- Click on "Ok"

-> Error

Tim Young [Elevate Software] schrieb:
> Ralf,
>
> << can we have a "Show Script"-Button or something like this in the
> Alter-Table-Dialog.
>
>  Sometimes i cant alter a tbale because of an error like this: >>
>
> How did the error occur ?  Are you specifying a DEFAULT or CHECK expression
> ?  Normally there won't be any errors because the SQL is all generated by
> the EDB Manager.
>
Image