*Hi Victor,
*On search in doc, I found related doc for you.
To pull information from external tables, you can use the Set Fields
action with the "Read Value for Field From" set to "SQL". This allows
you to send an SQL |SELECT| command to the database and assign the
return values to AR System fields. Observe the following general rules
for using SQL commands:
* You need not use every value that is returned from the SQL
command, but you must use at least one.
* You can use the same value in more than one field.
* You can issue only one SQL command per action. You cannot enter
two commands separated by a semicolon and have both commands run.
To run a set of commands, create separate actions, or create a
stored procedure and run that. (Stored procedures do not return
values.)
* Turn on AR System server SQL logging to debug the SQL syntax if it
returns unexpected values or results. A good debugging strategy is
to start an SQL interpreter (for example, isql for Sybase,
SQL*Plus for Oracle^® , Command Center for DB2, or Query Analyzer
for SQL Server) and to enter the same SQL command directly into
the database to verify its validity.
* Because there is no error checking on the SQL statement, run the
SQL statement directly against the database (as a test) before you
enter it into the SQL Command field. You can then copy and paste
the tested SQL command directly into the SQL Command field.
* If the SQL operation fails, an AR System error message and the
underlying database error message appear
* For more information about Set Fields action with SQL, see the
/Workflow Objects/ guide.
Hope this helps...
Regards,
*Sandeep
Vyom Labs Pvt. Ltd.
An ISO 20000 certified company.
Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL
Web : www.vyomlabs.com
>*
Victor wrote:
Hello Listers,
It is possible to populate a table field with the result from an sql query?
Any idea how this could be done?
Victor
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
