Subject | Alter Domain example needed |
---|---|
Author | bmckenna6 |
Post date | 2002-06-17T23:57:09Z |
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.
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.