Subject RE: [IBO] Data Types in IBO
Author Helen Borrie
At 10:44 AM 29/04/2004 -0400, you wrote:
>Ok, have it compiled and running. Relations tab found by clicking the Browse
>Database icon, correct? Tables and System Inf. are both checked.
>
>Selected RDB$TYPES. Showing RDB$FIELD_NAME, RDB$TYPE, RDB$TYPE_NAME,
>RDB$DESCRIPTION, RDB$SYSTEM_FLAG, DB_KEY, and these are controllable in the
>Field Names List tab. RDB$TYPE is a smallint, and apparently contains the
>number I need. Then by selecting a table of interest, presumably the
>RDB%TYPE number should be displayed?

Sorry, I can't work out what you want here. RDB$TYPES contains the
enumerated types. The group whose RDB$FIELD_NAME IS "RDB$FIELD_TYPE" are
the data types. For each of these, the smallint RBB$TYPE is the number
that IBO returns in the SqlType property of the TIB_Column after
Prepare. In the case of BLOB, RDB$SUB_TYPE is returned as well, in the
property SQLSubType.

What I'd suggested was that you map the RDB$TYPE numbers that you are
interested in to the <input> tags that you want to use with each in your HTML.

Helen