I have a sql function which gives back a parameter, how can I call the function and put this parameter in a remedy field?. How can I call this function in a Set Fields to put the parameter in a field of a form?

Thanks


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

On Thu, 30 Dec 2004 11:29:20 +0100, Ramón Zaragoza García wrote:

>I have a sql function which gives back a parameter, how can I call the function and put this parameter in a remedy field?. How can I call this function in a Set Fields to put the parameter in a field of a form?

>From memory :-)

set fields from sql

sql statement

begin; ; end;

--
Regards

Dave Saville


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

You say it gives back a parameter... Is this a function or a procedure? What DB are you using?

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ramón Zaragoza García
Sent: Thursday, December 30, 2004 4:29 AM
To: arslist@ARSLIST.ORG
Subject: SQL FUNCTION PARAMETER


**

I have a sql function which gives back a parameter, how can I call the function and put this parameter in a remedy field?. How can I call this function in a Set Fields to put the parameter in a field of a form?



Thanks





UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

The function result is set to a field using $1$ syntax for the first value returned ($2$ for a second result, etc.).

This value is also selectable from the Set Fields menu next to the "Value" setting, as "SQL Result Column".

Mike Luttmann
Michael.Luttmann@peterson.af.mil

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dave Saville
Sent: Thursday, December 30, 2004 4:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL FUNCTION PARAMETER

On Thu, 30 Dec 2004 11:29:20 +0100, Ramón Zaragoza García wrote:

>I have a sql function which gives back a parameter, how can I call the function and put this parameter in a remedy field?. How can I call this function in a Set Fields to put the parameter in a field of a form?

>From memory :-)

set fields from sql

sql statement

begin; ; end;

--
Regards

Dave Saville


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)