p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB Databases Basics (http://p2p.wrox.com/forumdisplay.php?f=82)
-   -   how to call oracle function in VB6. please help me..? (http://p2p.wrox.com/showthread.php?t=89802)

isa75 April 7th, 2013 06:00 AM

how to call oracle function in VB6. please help me..?
 
guys, please help me..?
i have script oracle function this below
CREATE OR REPLACE FUNCTION hitung_hari (b registrasi.id_reg%type) RETURN NUMBER IS
hari NUMBER;
BEGIN
select
trunc(to_date(masa_berlaku) – to_date(sysdate))
into hari from registrasi where id_reg=b;
return hari;
END hitung_hari;
/

and I want to call the above function in VB6.
I have 1 buttonHasil, 1 textboxA and 1 textboxB.
and if I enter into textboxA id_reg then I click the button Hasil the results are appearing in textboxB.

please help me..? please .. [:confused:]


All times are GMT -4. The time now is 03:33 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.