Hi Lisa,
This may apply to your situation:
Use the Direct SQL action to submit any legal SQL command to the database.
The Direct SQL action has a different result than the SQL command you use
to set a field value in the Set Fields action. In the Set Fields action,
you use
SQL to query the database for information and then use the returned value
to set a field. With the Direct SQL action, the SQL command is not expected
to return data. For example, you can define a Direct SQL action to perform
inserts or updates to a database.
I pulled this from the Workflow Objects 7.0 manual, page 64.
Rick Ponzo
IntegrITS Corp
Kemes, Lisa wrote:
**
I have a SQL Statement on my Active Link that's like: Select * from
gbl_ship...@xyz_gewp2.
It's not working, so I turned on the SQL Logs (in the Admin Tool) and
it's showing: Select * from gbl_ship_to_someth...@aaa_dkw2. (I'm
making names up here).
The fact is that my SQL Statement on my AL is different than it is in
the logs.
When I run gbl_ship...@xyz_gewp2 straight from the database it works,
so I don't think it's a db problem.
Anyone ever see this before?
ARS 7.1
Oracle 10i
Windows 2003 Server
*Lisa Kemes** *
AR System Developer
Tyco Electronics
717-810-2408 tel
717-810-2124 fax
[email protected]
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
