Kalau pake view bisa pake kaya select biasa
Cth :
Set rs = cn.execute("select * From nama_view")
Kalau pake function bisa pake
Set rs = cn.execute("select * From nama_fc('parameter1','parameter2') ")
Kalau pake SP ya bisa sihh dapet return valuenya but balik lagi ke pelajaran
basi kalau gakk salah ya
Bedanya procedure ama function itu kan procedure dakk ada retun valuenya
sedang function ada. Tapi kalau di paksa bisa kok procedure dapet return
falue
Set rs =cn.execut( exec nama_sp 'parameter1','arameter2')
T'rims
Sukisno
_____
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of dwi saputro
Sent: Friday, June 15, 2007 4:17 PM
To: [email protected]
Subject: Re: [Programmer-VB] record dari stored procedure
mas sukis,
gimana, kalo mau bikin view dan kita execute dari VB code kita, terus
hasilnya recordset nya langsung dapat kita pake di coding?
gimana mas, soalnya saya belum pernah pake view di vb
thanks
----- Original Message ----
From: sukisno K <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, June 15, 2007 3:08:26 PM
Subject: RE: [Programmer-VB] record dari stored procedure
Mass Kayanya kalau mau pake view or pake function dehh jangan pake SP
_____
From: Programmer-VB@ yahoogroups. com [mailto: Programmer-VB@ yahoogroups.
com ] On Behalf Of dwi saputro
Sent: Friday, June 15, 2007 1:31 PM
To: Programmer-VB@ yahoogroups. com
Subject: [Programmer- VB] record dari stored procedure
alo guys,
mau tanya nih, gimana caranya dapat record yang kita execute pake stored
procedure (SQL)
thanks before
_____
Got a little couch potato?
Check out fun summer activities for kids.
<http://us.rd.yahoo.com/evt=48248/*http:/search.yahoo.com/search?fr=oni_on_m
ail&p=summer+activities+for+kids&cs=bz>
_____
Never
<http://us.rd.yahoo.com/evt=49938/*http:/tools.search.yahoo.com/toolbar/feat
ures/mail/> miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.
