|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
stored procedures + vb net = HELP
I have made a procedure using FENISql and it looks like this:
set term !!; /*QC - QUEUE_CONTROL - keepeing the sequence of FIFO*/ create procedure foo (Buf_Num int) Returns (Next_QC bigint) As /*for keeping current value of QC in asking BUFFER from tbl buffers*/ Declare Variable Temp_Result bigint; Begin Temp_Result = Null; SELECT first 1 QUEUE_CONTROL FROM Buffers WHERE BUFFER_NUMBER = :Buf_Num ORDER BY QUEUE_CONTROL DESC INTO :Temp_Result; If (Temp_Result is Null) Then Begin SELECT first 1 QUEUE_CONTROL FROM Main ORDER BY QUEUE_CONTROL ASC INTO :Next_QC; End Else Begin SELECT first 1 QUEUE_CONTROL FROM Main WHERE QUEUE_CONTROL > :Temp_Result ORDER BY QUEUE_CONTROL ASC INTO :Next_QC; End End!! set term ;!! /*---------------------------------------------------------*/ and I would like to lunch it from vb.net, I have got a componets ... but I can not put a parameters Can somebody can Help me ??Best Regrads |
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > stored procedures + vb net = HELP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|