Hi,
I'd like to know if there is the possibility to obtain the schema of temporary tables via ODBC.
For standard tables, it's possible using the command
Code:
Conn.GetSchema ("Columns", {Nothing, Nothing, TableName})
Into SQLServer exists the same command for standard tables and the following trick for temporary tables:
Code:
Conn.CreateRecordSet ("DECLARE @table_name As VARCHAR(300)" &
     "SET @table_name = (SELECT TOP 1 [name] FROM tempdb..sysobjects" &
     "  WHERE name LIKE '#Foo%')" &
     "EXEC tempdb..sp_columns @table_name")
There is something like this into Informix too?

Thanks