Hi,

I am using IBO 4.3.Aa for a project where I will use a customized Object Inspector to
fill the parameters of a Firebird 1.5/2.0 stored procedure. I would like to get
something like :

// Extracting parameters from ADD_EMP_PROJ
// Database = Employee.FDB
// Server = FB1.5

MyDDLExtractProx('ADD_EMP_PROJ', IBConnection ); // This returns in a TIBCursor with:

Record1) EMP_NO , Smallint, 0, 0
Record2) PROJ_ID, Char , 5, 0

I am using RDB$ tables to extract the info , but I get lost with some types I can't map:

FB Delphi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TEXT = CHAR = PAnsiChar?
SHORT = ShortInt?
LONG = Integer?
QUAD = INT64?
FLOAT = Double?
DOUBLE = DOUBLE?
TIMESTAMP = DATETIME?
VARYING = VARCHAR = PAnsiChar?
BLOB = ???? = ????
CSTRING = ???? = ????
BLOB_ID = ???? = ????
DATE = = DATETIME (Only Date part will be filled) ?
TIME = = DATETIME (Only Time part will be filled) ?
INT64 = = INT64 ?

What does RDB$FIELD_SUB_TYPE be used for? They are only used for BLOBs?


TIA for any light!
Clément