Re: How to get the form and field names?

[L. J. Head]

I created a view in the Db with this sql

CREATE VIEW dbo.ExistingFields
AS
SELECT     CAST(RTRIM(CAST(f.schemaId AS char)) + '' +
RTRIM(CAST(RIGHT(f.fieldId, 6) AS char)) AS int) AS RequestID, a.name AS
Form, a.schemaId AS FormID, 
                      f.fieldName, f.fieldId, f.fieldType, f.datatype,
f.fOption, f.createMode, f.defaultValue
FROM         dbo.arschema a INNER JOIN
                      dbo.field f ON a.schemaId = f.schemaId

I then imported this view form on top of it.  This allows me to lookup
fields and field ID's by form name or ID along with some basic attributes
about them...all of the cast for the request ID field is an attempt to make
a 15 char unique ID for the request ID.  Hope it's helpful to you

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Friday, September 21, 2007 2:58 AM
To: arslist@ARSLIST.ORG
Subject: How to get the form and field names?

Hi everyone,

I'd like to build a configurable application, where the admin can can
configure/enable different functions for certain part of the application. I
was wondering how to access form and field name and field ids. Acctualy I'd
need to show them in a table field. As far as I know there is no other way
to do to build a dictionary with all the form and field data. Does anyone
have a script do populate a form with the form, field names and ids?

Mark

____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

existingfields.def
Description: Binary data