In a "Set Fields" action, where you wish to read the value for a field
from SQL, and you want that value to be obtained from a SQL Server
stored procedure, the following code works:

EXEC pr_Remedy_GetExcelPath '$OS$'

The stored procedure is called "pr_Remedy_GetExcelPath", and appears as
follows:

CREATE PROCEDURE pr_Remedy_GetExcelPath
@OS varchar(255)
AS

IF @OS='Windows 2000'
 SELECT 'C:\Program Files\Microsoft Office\Office\Excel.exe' FROM
Control

IF @OS='Windows XP'
 SELECT 'C:\Program Files\Microsoft Office\Office11\Excel.exe' FROM
Control


Its purpose is to determine the correct path from which to execute Excel

depending on the operating system, so the one parameter is a varchar
value 
for OS.

Environment:
ARS 6.3
SQL Server 2000


Hope this helps,

Jim Ashton



_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to