Re: ESQL/C and SELECT *

On Tue, 16 Feb 1999, Martin Purdy wrote: > How come in ESQL/C, when I prepare the statement "SELECT * from fname > where KEY = '01'", all the columns in the record are not returned? They are. Since you're having problems, most probably because you didn't tell it where to put the data. You don't discuss how you've set up the host variables to receive the data, and there are multiple options (SQLDA, SQL DESCRIPTOR, plain host variables), so we can't be sure this is your problem, but it might easily be. > The same code returns columns where they are named in the select > statement. Do you mean that when you replace "SELECT *" with an enumerated list of column names, (as in "SELECT c1, c2, c3, ... FROM Fname WHERE KEY = '01'"), the ESQL/C code starts working? I'd need to see your code, and the schema for the fname table, before I believed you, I'm afraid. > PS. I'm using: > ESQL/C version 7.23.UC6 > SE version 7.23.UC13 and > ESQL/RT version 7.14.UD1 > All of the above are running under SCO UNIX version 5.0.5 Yours, Jonathan Leffler (jleffler@informix.com) #include <wish/I/was/skiing.h> Guardian of DBD::Informix v0.60 (v0.61_02) -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn