[firebase-br] Mudança de Float para Numeric(15, 2)

[Jhosef Marks]

Pessoal consegui esse script q altera no banco todos os campos do tipo Float
para Numeric(9, 2)

<file://///jhon/Minhas%20m%C3%BAsicas/Nirvana/>UPDATE RDB$FIELDS SET
RDB$FIELD_TYPE = 8, RDB$FIELD_SCALE = -2
WHERE RDB$FIELD_NAME IN ( SELECT RDB$RELATION_FIELDS.RDB$FIELD_SOURCE FROM
RDB$RELATION_FIELDS, RDB$FIELDS
WHERE (RDB$RELATION_FIELDS.RDB$FIELD_SOURCE = RDB$FIELDS.RDB$FIELD_NAME)
AND (RDB$FIELDS.RDB$FIELD_TYPE = 10 ) AND (RDB$FIELDS.RDB$SYSTEM_FLAG <> 1
));

soh q naum consegui alterar ele para converter para Decimal(15, 2) ou
Numeric(15, 2)....

Alguem poderia ajudar???
-- 
Jhosef Marks de Carvalho
Delphi Developer
Fone: +55 11 9453-6472
http://groups.google.com/group/soumaisdelphi