Return value from stored procedure in SQL 6.5 to VB4 to a 16 bits client 
Author Message
 Return value from stored procedure in SQL 6.5 to VB4 to a 16 bits client

_Posting again, anyone ever done this?_

I'm making a VB-program in Win 3.11 with VB 4.0 and using SQL Server 6.5 as
database and want to return values from my stored procedures.

I have earlier used VB4 against SQL with 32-bits clients and used rdo
prepared
statements to return values to my program. Now I want to return values from
my
stored procedures to a 16-bits client, (not only the rows affected)

There is no problem to tell the stored procedures that a parameter is a OUT

values, but I don't know who write the call string in VB. I have also tried

RETURN 12, it works with a 32-bits client and rdo, but not in 16-bit.

Mats



Tue, 20 Apr 1999 03:00:00 GMT  
 Return value from stored procedure in SQL 6.5 to VB4 to a 16 bits client

I dont believe that 16 bit Jet supports output parameters. (RDO is
only 32 bit). You may have to code this directly using the ODBC API.



Sat, 24 Apr 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Return a value from stored procedure in SQL 6.5 to VB4 to a 16 bits client

2. SQL 6.5 stored procedure - parameter not returning

3. Accessing SQL 6.5 Stored procedures thru VB4.0

4. Passing parameters from Excel to SQL 6.5 stored procedures

5. Stored Procedures with VB5/SQL Server 6.5

6. executing SQL Server 6.5 stored procedure using VB 5

7. S10008 Error From SQL Server 6.5 Running VB 5.0 Stored Procedures

8. sending parameters from VB 6 to SQL 6.5 stored procedure

9. ADO and SQL 6.5 sp_droplogin Stored procedure

10. VB 5.0 & Stored Procedure (SQL Server 6.5)

11. Passing parameters from Excel to SQL 6.5 stored procedures

12. SQL 6.5 Records via Stored Procedures

 

 
Powered by phpBB® Forum Software