Re: Re: Select

}>Jonathan Leffler: } }>Date: Tue, 28 Jan 1997 15:31:50 +0100 }>From: Keith bugeja <keith.bugeja@magnet.mt> }>X-Informix-List-Id: <list.12850> }> }>does anyone know if it is possible to get the name of the columns of a table }>using the 'execute procedure' to execute a procedure that contains a select }>statement. } }No, it isn't. I'm assuming that you have something like: } }CREATE PROCEDURE FetchIt() RETURNING INT, CHAR(30), ...; }DEFINE i INT, j CHAR(30), ...; }FOREACH SELECT * INTO i, j, ... FROM SomeTable } RETURN i, j, ... WITH RESUME; }END FOREACH; }END PROCEDURE; } }The return columns are all designated '(expression)' by the DESCRIBE }statement. } }Yours, }Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> } } Just a question: Is it possible to get the column names back using the above method using ODBC.