Stored Procedure returning result set to embedded SQL client


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Stored Procedure returning result set to embedded SQL client

  1. #1
    Guido Lamers Guest

    Stored Procedure returning result set to embedded SQL client


    Hi,

    I'am developing applications with the help of embedded SQL in C++ language.
    I want to use 'select' with more than one result (cursors) inside stored
    procedures. Documentation tells me the client can only be in CLI, ODBC, JDBC
    or SQLJ language.

    Is this true? And what can i do to use cursors in stored procedures called
    from a embedded SQL C++ application on Windows NT 4.0.

    Thanks,

    Guido Lamers


  2. #2
    Zamil Guest

    Re: Stored Procedure returning result set to embedded SQL client


    Guido,
    You should be able to do what you are trying to do.

    Look at the sample program
    ..\SQLLIB\samples\cpp\spclient.sqx OR
    ..\SQLLIB\samples\c\spclient.sqc

    These are sample programs that have examples of calls to stored procedures
    that return multiple result sets.

    Regards,
    Zamil

    "Guido Lamers" <GuidoLamers@hetnet.nl> wrote:
    >
    >Hi,
    >
    >I'am developing applications with the help of embedded SQL in C++ language.
    >I want to use 'select' with more than one result (cursors) inside stored
    >procedures. Documentation tells me the client can only be in CLI, ODBC,

    JDBC
    >or SQLJ language.
    >
    >Is this true? And what can i do to use cursors in stored procedures called
    >from a embedded SQL C++ application on Windows NT 4.0.
    >
    >Thanks,
    >
    >Guido Lamers
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center