Listers ~ I am getting the following error during a SQL set fields
action:
ARERR [552] Failure during SQL operation to the database : The max
function requires 1 argument(s). (SQL Server 174)
My SQL command is listed below and I can successfully run it from SQL
Server:
SELECT max($PO
] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:11 PM
To: arslist@ARSLIST.ORG
Subject: SQL statement error
**
Listers ~ I am getting the following error during a SQL set fields
action:
ARERR [552] Failure during SQL operation to the database : The max
function requires 1
-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:11 PM
To: arslist@ARSLIST.ORG
Subject: SQL statement error
**
Listers ~ I am getting the following error during a SQL set fields
action:
ARERR
)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
I'm not sure I understand. I want to auto-populate the PO Number field
with the next available PO #. I would like to accomplish
An: arslist@ARSLIST.ORG
Betreff: Re: SQL statement error
I'm not sure I understand. I want to auto-populate the PO Number field with
the next available PO #. I would like to accomplish this through direct SQL
rather than creating an additional field(s) and workflow?
Laurie Muhlethaler
(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
I'm not sure I understand. I want to auto-populate the PO Number field
with the next available PO #. I would like to accomplish
discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
I'm not sure I understand. I want to auto-populate the PO Number field
with the next available PO #. I would like
@ARSLIST.ORG
Subject: Re: SQL statement error
Yes - that's exactly what I'm doing. I am doing it via a Set Fields
action. I don't want to do this through a Direct SQL If Action, do I?
Laurie Muhlethaler
Remedy Developer / Administrator
On Wed, 17 Dec 2008 13:31:06 -0600, Opela, Gary L CTR USAF AFMC 72
CS
to $1$.
Norm
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
Yes - that's exactly what I'm doing. I am
...@arslist.org] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Wednesday, December 17, 2008 1:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
What I was trying to say in my original reply (and communicated poorly)
was that $PO Number$ tells Remedy to translate what's currently
] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 12:11 PM
To: arslist@ARSLIST.ORG
Subject: SQL statement error
**
Listers ~ I am getting the following error during a SQL set fields action:
ARERR [552] Failure during SQL operation to the database : The max function
requires 1
Check your ASR SQL log files and see exactly what the statement looks like.
On Wed, Dec 17, 2008 at 2:10 PM, Muhlethaler, Laurie
lmuhletha...@firstrepublic.com wrote:
**
Listers ~ I am getting the following error during a SQL set fields action:
ARERR [552] Failure during SQL operation
)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 12:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
I'm not sure I understand. I want to auto-populate the PO Number field with
the next available PO #. I would like to accomplish this through
to $1$.
Norm
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
Sent: Wednesday, December 17, 2008 1:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
Yes - that's exactly what I'm doing. I
setfield with direct SQL :)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72
CS/SCBAH
Sent: Wednesday, December 17, 2008 12:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL statement error
15 matches
Mail list logo