LJ Longwing wrote:
**
The alias you are looking for is going to be stored with the View, not the form itself, I don't know the tables, but I know how to get at it via the API. The reason it's stored there is because each view of a form can have its own alias.

The view alias and label name(s) can be found in the table field_dispprop. You need to look for rows where the schemaId is that of your schema and the fieldId is NULL. There is a row for each vuiId and in the propLong column you will find the information concerning view names and labels.

The structure of the propLong field is a bit complicated to describe in an email, but it consists of '\' delimited values detailing the values of the various properties of the view. The first number is the number of properties stored. For the view name look for the string '20\4\nn\<string>' where nn represents the length of the name string and <string> is that name. The label for "Entry Point, New Mode" is property number 5026 and that for "Entry Point, Search Mode" is 5027. If the label is empty then the property value will be displayed as 5026\4\0\\ (for New Mode).

I know it looks confusing but I hope this helps. Using the API is makes it much slightly easier to decipher as it separates out the properties for you, but you still have to work out some of the values for yourself.

Ian

------------------------------------------------------------------------
Ian Trimnell, AR System Lead Developer (amongst other jobs),
Specialist Support & Information Team, Academic & Administrative Computing Service
Open University, MILTON KEYNES, UK
Phone: 01908 653741   web: http://www.open.ac.uk/

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

Reply via email to