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

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

Hey Tim,

I'am just playing

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.
>