Hello Javed, Apparently there is no solution for this, but hey, Ingres is open source! We can hack ODBC driver and maybe even Ingres engine itself to support something like this:
> Create procedure rowproc ... as > ... result row (char(10) as name, varchar(50) as surname , char(3) as > age) ... > begin > ... what do you think? Best regards, Nicolai Tufar On Mon, 28 Mar 2005 15:30:40 +0300, Javed Khan Dalwai <[EMAIL PROTECTED]> wrote: > Hi All, > > I have following questions about stored procedures in Ingres. > 1. How can I get field names for the return row from row producing stored > procedure? > For example, lets say you have a stored procedure which returns multiple rows > with 'result row(...)' and 'return row(...)' statements. > Sample: > Create procedure rowproc ... as > ... result row (char(10), varchar(50), char(3)) ... > begin > ... > for > select userid, username, dept > into :a, :b, :c > from personnel > ... > return row (:a, :b, :c); > endfor; > ... > end; > > My client is Visual Foxpro 8.0 (VFP) and I Ingres ODBC on Windows XP machine. > When I call this procedure from VFP-ODBC-Ingres, the resulting table fields > (in VFP) I get are as follows: > result_element0, result_element1, result_element2 > Since, I refer to the result columns with their names, I would like the name > of the return fields to be userid, username, dept. > > 2. Is stored procedure parameter value case-sensitive? Can we change this > behavior through environment vars? > > Thanks in advance. > > Best Regards, > Javed Dalwai, > > _______________________________________________ > Users mailing list > Users@ingres.ca.com > http://ingres.ca.com/mailman/listinfo/users > _______________________________________________ Users mailing list Users@ingres.ca.com http://ingres.ca.com/mailman/listinfo/users
