MS ACCESS MAILING LIST: Re: Bls: [belajar-access] Excute Store Procedure Di Access

Saturday, July 14, 2012

Re: Bls: [belajar-access] Excute Store Procedure Di Access

Bismillahir rahmanir rahim....

Terimakasih Mas Hendra. Ini sedikit pengalaman saya. Kalau di database MySql script penggunaan store prosedure melalui vba sbb:

Private Sub Command5_Click()
Dim aa As Variant
Dim rsp As ADODB.Recordset

    KONEKSI
    If conn.State <> 0 Then
        aa = ""
        Set rsp = conn.Execute("call P1('" & text1 & "');")
        If Not rsp.EOF Then
            Do While Not rsp.EOF
                aa = aa & rsp.Fields(0) & vbCrLf
                rsp.MoveNext
            Loop
        End If
    End If
    conn.Close
    Set conn = Nothing
    MsgBox aa
End Sub

Di dalam database MySql, sebelumnya sudah dibuat SP. Contohnya:

CREATE PROCEDURE `P1`(in name char(255))
begin
SELECT Nama_Masalah
FROM BU_MASALAH where masalah=name;
end;

Semoga bermanfaat..

Hariyanto (Surabaya)

http://110.139.57.19

--- On Tue, 10/7/12, Alu Syafrudin <alualde@rocketmail.com> wrote:

From: Alu Syafrudin <alualde@rocketmail.com>
Subject: Bls: [belajar-access] Excute Store Procedure Di Access
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Date: Tuesday, 10 July, 2012, 9:02 AM

ane lagi punya pikiran aja nich ( he . . he . . lagi benar ^_^ ), kira2 bisa ga yak Excute Store Procedure Di Access . .

eh pas ane buka linknya dan tulisannya pake bahasa inggris ( translate dulu di google ^_^ hi . . hi . . hi . . ) . . ternyata bisa toh Excute Store Procedure Di Access . .

Terima kasih mas hendra atas linknya . .

.: alu :.

Dari: Hendra Agestha Hamid <the_agestha@yahoo.com>
Kepada: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Dikirim: Senin, 9 Juli 2012 21:32
Judul: Re: [belajar-access] Excute Store Procedure Di Access

Dear mas Alu,...saya blm pernah sih...tapi ini saya coba googling,,,mingkin bisa membantu :

http://www.google.co.id/#hl=id&sclient=psy-ab&q=MS+ACCESS+VBA+TO+RUN+STORED+PROCEDURE&oq=MS+ACCESS+VBA+TO+RUN+STORED+PROCEDURE&gs_l=hp.3...21282.48432.0.48979.37.34.0.3.3.0.195.5008.0j34.34.0...0.0.8NxWI3uf5Jo&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=d9fc77ef60d7bc93&biw=1366&bih=574

Mas Hari Yanto nih yg harusnya jawab... :)

Regards
Hendra

From: Alu Syafrudin <alualde@rocketmail.com>
To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
Sent: Monday, July 9, 2012 3:00 PM
Subject: [belajar-access] Excute Store Procedure Di Access

Dear Para Access,

Mau Tanya dong...ane udah browsing sana sini tapi bingung...

ane membuat store procedure di sql tapi ane ingin excute store procedurenya di access pakai command button.
kira2 ada yang punya contohnya ga..??? ^_^

.: alu :.