Visual Basic and ADO With CLI SDK 2.4 
Author Message
 Visual Basic and ADO With CLI SDK 2.4
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.
I am more than happy with executing stored procedure from VB, but am
unfamiliar with Informix SP's.

Thank's in Advance.

Neil

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Visual Basic and ADO With CLI SDK 2.4


Quote:

> 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:

CREATE PROCEDURE params()
   RETURNING  CHAR(15),
              CHAR(15);
   DEFINE l_name   char(15);
   DEFINE f_name   char(15);
   foreach
       select lname, fname
         into l_name, f_name
         from customer

       return l_name, f_name with resume;
   end foreach;
end procedure;

--
Tom Kliethermes     90% of people give the rest of us a bad name.
"Not answering this post implies that you believe everything I
have said."

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Visual Basic and ADO With CLI SDK 2.4


Quote:


> > 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.



Mon, 14 Apr 2003 19:02:23 GMT
 Visual Basic and ADO With CLI SDK 2.4

Quote:
> all named (expression). Is there any way the Stored Procedure can
> assign alias's to the returned values?

Answer - No.

Sergey.


Quote:




> > > 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.



Mon, 14 Apr 2003 19:20:49 GMT
 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 table
example
select firstname + ' ' + lastname as fullname from tblNames
from http://www.gbcGLOBAL.com

Quote:
>-----Original Message-----


>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.






>>> > > 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!


Tue, 15 Apr 2003 11:49:17 GMT
 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 table
example
select firstname + ' ' + lastname as fullname from tblNames

Quote:
-----Original Message-----


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.






>> > > 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!


Tue, 15 Apr 2003 11:48:47 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. CA-Los Gatos-263948--ORACLE-RDBMS-Client/Server-Windows-UNIX-Visual Basic-Visual

2. Client SDK 2.4

3. VA-Arlington-240606--Visual Basic-ADO-COM-ORACLE-SQLSERVER-Active-X-ASP-Visual Basic

4. VA-Arlington-240606--Visual Basic-ADO-COM-ORACLE-SQLSERVER-Active-X-ASP-Visual Basic

5. CA-Orange County-251168--Visual Basic-Active-X-ADO-ORACLE-SQLSERVER-Visual Basic Developer

6. Visual Basic 5 with Informix CLI 2.5

7. Visual Basic 5 with Informix CLI 2.5

8. Problems with INFORMIX-CLI, INFORMIX-OnLine 5.x., Visual Basic 4, Win95

9. database Pervasive SDK 7 + Visual Basic 6

10. IL-CHICAGO-138941--Visual Basic-SQLSERVER-RDBMS-ORACLE-Management-Visual Foxpro-Visual Basic Developer

11. VA-Fairfax-240589--Visual Basic-SQLSERVER-ORACLE-ADO-Client/Server-Active-X-Visual Basic Developer

12. OH-CINCINNATI-105470--Visual Basic-ORACLE-Visual C++-MFC-OOD-Visual Basic Programmer


 
Powered by phpBB® Forum Software