Hello again, For the benefit of others who may have had this problem, I have not yet found the exact solution to retrieve captions. However, I am using a work around for the same.
The work around is that I have the Caption of the field stored in the description of the field followed by a special character which would typically not be used in a caption e.g. ":". So my description reads something like: Field Name = TRH_APP_Code Description = Application Code: This field contains the Application Code etc etc... In processing, I use the dbschemas.asp script to retrieve the description (28th piece of information) and then search for ":" in that field and using Mid function retrieve position 1 through the (position of the ":" - 1) and get my caption created. Hope this helps. Cheers! Uttam --------------- --- In [email protected], "qa_director_2003" <[EMAIL PROTECTED]> wrote: > Hello, > > I am currently in the process of creating a Universal Master Table > Duplicate Key Check program in ASP. One of my challenges is to get the > appropriate Caption for the fields from the table itself. > > I use a variant of the dbSchemas.asp script to retrieve and determine > what fields are in the table chosen as also which of those fields are > key fields. But the caption for the fields are forced to be the field > name as I don't know where I can get the Captions defined for each > field in the tables. > > Any help here? > > Thanks in advance. > > Uttam Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
