Dipti,
Here is a SQL Server method to get the FieldId of an attachment field
(or any field) :
CREATE FUNCTION dbo.udf_GetFieldId
(
@FormName VARCHAR(60),
@FieldName VARCHAR(60)
)
RETURNS INT
BEGIN
RETURN (SELECT b.FieldID
FROM arschema a
JOIN [field] b
ON a.SchemaID = b.SchemaID
WHERE a.[name] = @FormName
AND b.FieldName = @FieldName)
END
In your workflow, issue a Set Fields SQL command like this:
SELECT dbo.udf_GetFieldId('CHG:Change', 'Test Plan')
HTH
Stephen
Remedy Skilled Professional
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Deepti
Sent: Thursday, September 27, 2007 4:06 AM
To: [email protected]
Subject: Is it possible to fetch the database id
**
Hi All
Is it possible to fetch the selected attachment field's database id
which is inside the attachment pool thro work flow
which is inside the attachment pool thro work flow
please let me know
thanks
dipti
________________________________
size=1 width="100%" align=center>
Unlimited freedom, unlimited storage. Get it now
<http://in.rd.yahoo.com/tagline_mail_2/*http:/help.yahoo.com/l/in/yahoo/
mail/yahoomail/tools/tools-08.html/>
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
