"OPENDATASOURCE" is a SQL Server-specific function. I don't know
whether there is a similar function for Oracle, as I am not very
familiar with the product. However I did find the following link which
discusses using Oracle to connect to an Access database, which may be of
some use to you:
http:/
ot;Action Request System discussion list(ARSList)"
04/17/2009 10:34 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: SQL statement
**
The following works for SQL Server in a similar situation. Not sure what
the corollary to "OPENDATASOU
The following works for SQL Server in a similar situation. Not sure
what the corollary to "OPENDATASOURCE" is for Oracle.
SELECT X.* FROM OPENDATASOURCE('Microsoft.jet.OLEDB.4.0',
'Data Source=\\usranfb\transfer\Shopinfo\shopdetail.mdb;
Jet OLEDB:Database Password=;')... X
WHERE SHOP_PFCNTR = $Sh
John
You'll need a "database link" set up. One for your dba I would imagine.
Matt
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of John Kelley
Sent: 16 April 2009 22:14
To: arslist@ARSLIST.ORG
Subject: SQL statement
Need a little help w
I don't know if you can do what you are attempting to do. Normally a Set
Fields SQL statement reads from the ARSystem database. Look at your error
message it's an Oracle error. I'm assuming your underlying database is Oracle,
correct?
--
Chris Danaceau
AttivaSoft Solutions Architect
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
If
AST_PurchaseOrder
>
>And then just set PO Number in the SET FIELDS action to $1$.
>
>Norm
>
>
>
>
>-Original Message-
>From: Action Request System discussion list(ARSList)
>[mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie
>Sent: Wednesday, Decem
)
[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 th
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 ope
usually the value within max() is a field name, not what I would expect you
have in the $PO Number$ field. You need to replace $PO Number$ with a field
name that you are wanting the max value of.
_
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behal
:arsl...@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 curren
the SET FIELDS action 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
slist@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
-Original Message-
>From: Action Request System 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 underst
Message-
>From: Action Request System 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-
)
[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
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
Remedy Developer / Administrator
On Wed, 17 Dec 2008 13:15:41
Looks like $PO Number$ is a field reference and Remedy is passing the
contents of PO Number (not the field name) to SQL, which is likely NULL
because the field is empty when you run this.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] O
18 matches
Mail list logo