Temp tables info

Is there any way to obtain this information from a temp table ? ... select coltype,collength into tipodat, londat from syscolumns where tabid=(select tabid from systables where tabname=tabla) and colname=campo... We have made a report compiler and need this information but temp tables do not seem to appear in the catalog ? I need this information to transform the content of the fields. I am treating columns not found as character, so numerical values are left justified instead of right justified. Any idea? Thanks in advance ¿Hay alguna manera de sacar información de las columnas de una tabla temporal? Tenemos un compilador de listados y necesito saber el tipo de columna para realizar un tratamiento u otro. Mi problema ahora es que me justifica los numericos a la izquierda en vez de a la derecha. Gracias de antemano -- Evelio Martínez Tel: +34 96 337-95-80 Fax: +34 96 337-81-18

Try preparing a "SELECT * FROM <temptable>" statement and DESCRIBE it into an sqlda structure or DESCRIPTOR and you can get the actual data types from that strucure then just FREE the statement. Art S. Kagel Evelio Martínez wrote: > Is there any way to obtain this information from a temp table ? > ... > select coltype,collength into tipodat, londat > from syscolumns > where tabid=(select tabid from systables where tabname=tabla) and > colname=campo> ... > > We have made a report compiler and need this information but temp tables > do not seem to appear in > the catalog ? > I need this information to transform the content of the fields. I am > treating columns not found as character, so numerical values > are left justified instead of right justified. > > Any idea? > > Thanks in advance > > ¿Hay alguna manera de sacar información de las columnas de una tabla > temporal? > Tenemos un compilador de listados y necesito saber el tipo de columna > para realizar un tratamiento u otro. > Mi problema ahora es que me justifica los numericos a la izquierda en > vez de a la derecha. > > Gracias de antemano > -- > Evelio Martínez > Tel: +34 96 337-95-80 > Fax: +34 96 337-81-18