Ou seja a coluna numeric e decimal ficar na mesma posição das outras?
¿Es esta la forma de seleccionar igual a IBExpert?
En palabras de otros, y la columna numérica decimal estar en la misma posición de la otra?
SELECT rdb$relation_fields.rdb$field_name Nome_Campo, CASE WHEN rdb$types.rdb$type_name = 'VARYING' THEN 'varchar' WHEN rdb$types.rdb$type_name = 'INT64' THEN 'numeric' WHEN rdb$types.rdb$type_name = 'LONG' THEN 'integer' WHEN rdb$types.rdb$type_name = 'TIMESTAMP' THEN 'timestamp' WHEN rdb$types.rdb$type_name = 'TEXT' THEN 'char' WHEN rdb$types.rdb$type_name = 'BLOB' THEN 'blob' WHEN rdb$types.rdb$type_name = 'FLOAT' THEN 'float' WHEN rdb$types.rdb$type_name = 'DATE' THEN 'date' WHEN rdb$types.rdb$type_name = 'DOUBLE' THEN 'double_precision' WHEN rdb$types.rdb$type_name = 'SHORT' THEN 'smallint' WHEN rdb$types.rdb$type_name = 'TIME' THEN 'time' WHEN rdb$types.rdb$type_name = 'BIGINT' THEN 'bigint' ELSE rdb$types.rdb$type_name END Tipo_Campo, rdb$fields.rdb$field_length Tamanho, rdb$fields.rdb$field_precision Valor, CASE WHEN rdb$fields.rdb$field_scale = -1 THEN 1 WHEN rdb$fields.rdb$field_scale = -2 THEN 2 WHEN rdb$fields.rdb$field_scale = -3 THEN 3 WHEN rdb$fields.rdb$field_scale = -4 THEN 4 WHEN rdb$fields.rdb$field_scale = -5 THEN 5 WHEN rdb$fields.rdb$field_scale = -6 THEN 6 WHEN rdb$fields.rdb$field_scale = -7 THEN 7 WHEN rdb$fields.rdb$field_scale = -8 THEN 8 WHEN rdb$fields.rdb$field_scale = -9 THEN 9 END Decimais, rdb$fields.rdb$field_sub_type Sub_Tipo FROM rdb$relation_fields, rdb$fields, rdb$types WHERE (rdb$relation_fields.rdb$relation_name = :busca)AND (rdb$fields.rdb$field_name = rdb$relation_fields.rdb$field_source)AND (rdb$types.rdb$type = rdb$fields.rdb$field_type)AND (rdb$types.rdb$field_name = 'RDB$FIELD_TYPE') ORDER BY rdb$field_position
Atenciosamente,
Adriano.