rs.open "insert into tblname values('" & a & "','" & b & "')",[connectionname],1,1
atau
[connectionname].execute "insert into tblname values('" & a & "','" & b & "')"
maka dengan store procedure kita gunakan:
rs.open "[store procedure name]",connection,1,1
atau
[connectionname].execute "[store procedure name]"
Semoga membantu
--aL--
Mareta Mujiburrachman <[EMAIL PROTECTED]> wrote:
Dear all VBers,
Mohon penjelasan dong tentang stored procedure..
Saya lagi belajar2 untuk membuat stored procedure di oracle, nah saya
ingin mencoba memasukkan stored procedure tersebut dalam vb, misal saya
ingin mensave dari form vb dengan script yang ada di stored procedure..
Cari manggil stored procedure itu di vb bagaimana ya kalo saya
menggunakan ADODC/ADODB?
Atas penjelasan rekan2 thx b4
Thanx and Regards,
Mareta Mujiburrachman
===================== ========= ========= ========= =========
This e-mail, including any attachment is confidential and may be privileged. Use or disclosure of it by anyone other than an intended adressee is strictly prohibited. If you are not an intended addressee, please notify the sender by telephone or e-mail and delete the e-mail and any attachment from your system.
PT Excelcomindo Pratama Tbk. ("the " Company") does not accept any liability in respect of communication made by its employee which is contrary to the company policy or outside the scope of the employment of the individual concerned. The employee responsible will be personally liable for any damages or other liability arising.
===================== ========= ========= ========= =========
Get your email and more, right on the new Yahoo.com __._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Indonesia phone card | Programmer | Indonesia tour |
| Indonesia travel | Indonesia flower |
Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
