yup, persis,
tapi tolong dong kalau masalah sudah selesai di infokan juga kemari, jadi
bisa membagi ilmu pengetahuan bagi rekan2 yang lain, yang sebenarnya punya
pertanyaan yang sama.
jika rs hanya mengembalikan satu field saja, anda bisa gunakan:
cNormalValue = rsFunction(0)
saja
aksan kurdin
On 4/18/08, Putra, Setyana <[EMAIL PROTECTED]> wrote:
>
> Terimakasih pa Aksan,
> sebetulnya tujuannya ingin mengambil result dari function di SQL server
> ,hanya saya kurang mengerti jika menggunakan cmd Object yang biasa saya
> gunakan u/ stored procedure
>
> akhirnya saya sudah dapat caranya
>
> Set rsFunction = New ADODB.Recordset
> rsFunction.Open "SELECT dbo.GetNormalValue('" & rsReport("NoAccount") &
> "') AS Result", Application.CurrentProject.Connection, adOpenKeyset,
> adLockReadOnly
>
> cNormalValue = rsFunction("Result")
>
> Jika ada cara yang lain, thx atas suggestionnya.
>
> Regards,
> Sst
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected] <[email protected]>]On
> Behalf Of aksan kurdin
> Sent: April 17, 2008 6:20 PM
> To: [email protected]
> Subject: Re: [belajar-access] Tanya get function di adp
>
> coba berikan contoh dengan cmd object yang anda lakukan, kita coba
> replace dengan perintah yang lebih singkat.
>
> aksan kurdin
>
> On Mon, Apr 7, 2008 at 10:49 AM, Putra, Setyana <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >
> >
> >
> >
> >
> > Rekan2,
> >
> > Mau tanya ada yang sudah pernah call SQLServer function lewat ADP,
> selain
> > lewat cmd object
> > ada cara lain ga ya ? (yang cuman 1 line) karena cmd object terlalu
> panjang
> > syntaxnya..
> >
> > Regards,
> > Setyana
> > IMPORTANT NOTICE:
> > The information in this email (and any attachments) is confidential. If
> you
> > are not the intended recipient, you must not use or disseminate the
> > information. If you have received this email in error, please
> immediately
> > notify me by "Reply" command and permanently delete the original and any
> > copies or printouts thereof. Although this email and any attachments are
> > believed to be free of any virus or other defect that might affect any
> > computer system into which it is received and opened, it is the
> > responsibility of the recipient to ensure that it is virus free and no
> > responsibility is accepted by American International Group, Inc. or its
> > subsidiaries or affiliates either jointly or severally, for any loss or
> > damage arising in any way from its use.
> >
>
>
> --
> Aksan Kurdin
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
>
>
> The information in this email (and any attachments) is confidential. If
> you are not the intended recipient, you must not use or disseminate the
> information. If you have received this email in error, please immediately
> notify me by "Reply" command and permanently delete the original and any
> copies or printouts thereof. Although this email and any attachments are
> believed to be free of any virus or other defect that might affect any
> computer system into which it is received and opened, it is the
> responsibility of the recipient to ensure that it is virus free and no
> responsibility is accepted by American International Group, Inc. or its
> subsidiaries or affiliates either jointly or severally, for any loss or
> damage arising in any way from its use.
>
>
--
Aksan Kurdin
