Re: Temp tables info

From: Evelio Mart'nez <programacionaf@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