Temp tables info

[Evelio Martínez]

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

[Obnoxio The Clown]

From: Evelio Martínez <program...@sinix.net>

>
>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
>...

What happens if you try

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

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

[Art S. Kagel]

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
> ...
>