Sujatha, If you haven't changed the name of the label after creating it once, then it would be the same as the database name and you can use this query to get that name which corresponds to the Label name.
SELECT Fieldname FROM field WHERE schemaId =<Schema_ID> AND fieldName='<Field_name>' to getthe schema_id of a form use this: SELECT schemaid from arschema WHERE name ='<Name of the form>' when you first create any field and the whatever label you create is assigned as database name. HTH Ankur -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sujatha Shanmugasundaram Sent: Monday, October 16, 2006 3:21 PM To: [email protected] Subject: Need Help Hi All, Do anyone know how to retrieve the Field Label for a particular Form through SQL Query?? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
