Re: Visual Basic and ADO With CLI SDK 2.4

you can write your stored proc to use and alias on the field that you select in your select statement. For example create an SP like select field as alias from tableexample select firstname + ' ' + lastname as fullname from tblNames from http://www.gbcGLOBAL.com >-----Original Message----- >From: Sergey E. Volkov <sve@raiden.bancorp.ru> >To: informix-list@iiug.org <informix-list@iiug.org> >Date: Thursday, October 26, 2000 10:49 AM >Subject: Re: Visual Basic and ADO With CLI SDK 2.4 > > >>> all named (expression). Is there any way the Stored Procedure can >>> assign alias's to the returned values? >> >>Answer - No. >> >>Sergey. >> >> >><neilrbcl@my-deja.com> ''''' ' ''''''''':8t92vt$6sr$1@nnrp1.deja.com... >>> In article <8t72eu$ich$1@nnrp1.deja.com>, >>> thamus <thamus@my-deja.com> wrote: >>> > In article <8t6ctd$vpl$1@nnrp1.deja.com>, >>> > neilrbcl@my-deja.com wrote: >>> > > Can anybody advise, from experience, on what the contents of a >>> simple >>> > > Informix Stored Procedure would look like to return the entire >>> > > contents >>> > > of an SQL Select statement to an ADO recordset in VB would look >>> like. >>> > >>> > As far as Informix is concerned, it doesn't matter if the >>> > client is VB or not. Here's one I had in my archive: >>> > >>> >>> Many thanks for that. I dont suppose that you have had experience of >>> return recordsets to ADO? Using the idea that you responded with >>> worked fine for me, except that I now have a recordset with 11 fields >>> all named (expression). Is there any way the Stored Procedure can >>> assign alias's to the returned values? >>> >>> Thanks again. >>> >>> Neil. >>> >>> >>> Sent via Deja.com http://www.deja.com/ >>> Before you buy. >> >> >> > _________________________________________________________________ Get your FREE e-mail at EnviroOne.com (http://www.EnviroOne.com), your one-stop Environmental center!