Stored Functions in Visual Basic

mdabyo
12-16-2003, 11:02 AM
Hey guys, i have what i am sure if a simple question. i am trying to call a stored function from VB using an ADO connection:

This is my function:

function F_Get_New_BNum
return number is
begin
declare
BNum number := 0;
begin
select max(batchnumber)
into BNum
from licence.batchprint;
BNum := BNum + 1;
return BNum;
end;
end F_Get_New_BNum;

how someone can give me a hand.

Thanks

-J

Dennis DVR
12-16-2003, 11:06 AM
Hey guys, i have what i am sure if a simple question. i am trying to call a stored function from VB using an ADO connection:

This is my function:

function F_Get_New_BNum
return number is
begin
declare
BNum number := 0;
begin
select max(batchnumber)
into BNum
from licence.batchprint;
BNum := BNum + 1;
return BNum;
end;
end F_Get_New_BNum;

how someone can give me a hand.

Thanks

-J

is this sql or pl sql

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum