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] 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
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.
