Subject Alter Domain example needed
Author bmckenna6
I'm new to IB.

My original Paradox to IB6 conversion used the script

CREATE DOMAIN D_NUMERIC NUMERIC(15,8);

As a side note, the actual definiton now appears to
be NUMERIC(18,8).

I now want to alter this to DECIMAL(18,8).

When I prepare a script in the IB_SQL DSQL window, I'm getting
an error:

The Script:

ALTER DOMAIN D_NUMERIC TO DECIMAL(18,8);


The Error:

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 27
DECIMAL

STATEMENT:
TIB_DSQL: "<TApplication>.frmSQL.frmDSQL.dsqlEdit."

1. How do I interpret this error. I've looked at the LangRef
but I know I need a bit of a clue to get into this...

2. If possible, a correct script example to help me along
would be greatly appreciated.