|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Firebird SP in VB6
in MSSQL a stored procedure are like this:
Create Procedure "ProcName" As Select "fields" From "Database" End Procedure If i have a conection obj and a recordser obj i use: Set Rs = con.Execute And that returns a recordset for use in my app. But in Firebid the Sp are like this: For Select "fields" From "Database" Into :"OutVariables" This Sp dosn´t return a Recordset for my app. What can i Do to have a recordset in VB6. Please sorry for my english. Diego Bs. As. -Argentina- |
|
#2
|
|||
|
|||
|
Check the documentation about the command SUSPEND, it will make your SP to output whatever value you have in your varible to the calling program, and keep processing the next set of data.
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Firebird SP in VB6 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|