View Single Post
  #1 (permalink)  
Old April 7th, 2013, 06:00 AM
isa75 isa75 is offline
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 ..
Reply With Quote