Re: Retrieve database info using active link
Or... Use the Menu type of Data Dictionary in v6.x. It is basically a "Search" menu based on some of these most common issues. Specifically there is an option to list fields for a form (yes you can use a $fieldID$ reference in the form name in the Menu definition) and return a value like ;. Then a simple active link can "split" the value on the ";" and put the Field ID number somewhere and strip it from the field to leave just the field name for the users to see too. And if you go ONE step farther. Tools like the Special $PROCESS$ command "Application-Map-Ids-To-Names-L" could also map from DB name to the users choice of views of the form too. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 4/27/06, parikshit saxena <[EMAIL PROTECTED]> wrote: > > ** > Hi List > > Just for Info... > To get the details for the backend object tables( for scenarios like these), > information from Database reference guide > ARSystem data dictionary can be > referred. > > > Regards > Parikshit > > > [EMAIL PROTECTED] wrote: > > > ** > Hi Veeral > > Check SQL Table called "Field". This table contains'SchemaID', FieldID, > Fieldname etc. > > You can use Direct SQL to get values from this table 'Field". > > Best Regards > > Abdul Ghani MF > TIS,Wipro,Pune,India > Tel:+91-20-3910 2364 (Direct)/+91-20-22933700 Ext:52364 > Fax:+91-20-2293 4092 > Cell:+91-9850-9865-33 > > > From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veeral J Oza > Sent: Thursday, April 27, 2006 10:53 AM > To: arslist@ARSLIST.ORG > Subject: Retrieve database info using active link > > > ** > Hi, > > Here is what I am trying to do, I have a menu from which I select a form > name, On selecting a form name, I have all the fields name populated on > another menu. After selecting a particular field i want to store the database > id of that field in a hidden character field. > E.g. > Menu1->MyApp:Form1 > Menu2->Form1:Fieldname > zcharfield->databaseid of fieldname selected in menu2. > > Environment: > ARS 6.3 > SQL 2000 Server > > So how do i retrieve the databaseid of the fieldname selected? > Kindly help!! > > > Regards, > Veeral Oza > > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > > www.wipro.com > __20060125___This posting was submitted with HTML in it___ > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Retrieve database info using active link
** Hi List Just for Info... To get the details for the backend object tables( for scenarios like these), information from Database reference guide > ARSystem data dictionary can be referred. Regards Parikshit[EMAIL PROTECTED] wrote: ** Hi Veeral Check SQL Table called "Field". This table contains'SchemaID', FieldID, Fieldname etc. You can use Direct SQL to get values from this table 'Field". Best Regards Abdul Ghani MF TIS,Wipro,Pune,India Tel:+91-20-3910 2364 (Direct)/+91-20-22933700 Ext:52364 Fax:+91-20-2293 4092 Cell:+91-9850-9865-33 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veeral J OzaSent: Thursday, April 27, 2006 10:53 AMTo: arslist@ARSLIST.ORGSubject: Retrieve database info using active link ** Hi, Here is what I am trying to do, I have a menu from which I select a form name, On selecting a form name, I have all the fields name populated on another menu. After selecting a particular field i want to store the database id of that field in a hidden character field. E.g. Menu1->MyApp:Form1 Menu2->Form1:Fieldname zcharfield->databaseid of fieldname selected in menu2. Environment: ARS 6.3 SQL 2000 Server So how do i retrieve the databaseid of the fieldname selected? Kindly help!! Regards, Veeral Oza The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.www.wipro.com__20060125___This posting was submitted with HTML in it___ The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.www.wipro.com__20060125___This posting was submitted with HTML in it___ Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. __20060125___This posting was submitted with HTML in it___
Re: Retrieve database info using active link
** Hi Veeral Check SQL Table called "Field". This table contains'SchemaID', FieldID, Fieldname etc. You can use Direct SQL to get values from this table 'Field". Best Regards Abdul Ghani MF TIS,Wipro,Pune,India Tel:+91-20-3910 2364 (Direct)/+91-20-22933700 Ext:52364 Fax:+91-20-2293 4092 Cell:+91-9850-9865-33 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veeral J OzaSent: Thursday, April 27, 2006 10:53 AMTo: arslist@ARSLIST.ORGSubject: Retrieve database info using active link ** Hi, Here is what I am trying to do, I have a menu from which I select a form name, On selecting a form name, I have all the fields name populated on another menu. After selecting a particular field i want to store the database id of that field in a hidden character field. E.g. Menu1->MyApp:Form1 Menu2->Form1:Fieldname zcharfield->databaseid of fieldname selected in menu2. Environment: ARS 6.3 SQL 2000 Server So how do i retrieve the databaseid of the fieldname selected? Kindly help!! Regards, Veeral Oza The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.www.wipro.com__20060125___This posting was submitted with HTML in it___ The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __20060125___This posting was submitted with HTML in it___
Re: Retrieve database info using active link
** You will have to use a SQL menu. this menu will query the field table. please use the following SQL that will give a list of fieldid and field name for form Form11. change it accordingly. select fieldid,fieldname from field where schemaid = (select schemaid from arschema where name = 'form11') HTH -sam On 4/27/06, Veeral J Oza <[EMAIL PROTECTED]> wrote: ** Hi, Here is what I am trying to do, I have a menu from which I select a form name, On selecting a form name, I have all the fields name populated on another menu. After selecting a particular field i want to store the database id of that field in a hidden character field. E.g. Menu1->MyApp:Form1 Menu2->Form1:Fieldname zcharfield->databaseid of fieldname selected in menu2. Environment: ARS 6.3 SQL 2000 Server So how do i retrieve the databaseid of the fieldname selected? Kindly help!! Regards, Veeral Oza The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Retrieve database info using active link
** Hi, Here is what I am trying to do, I have a menu from which I select a form name, On selecting a form name, I have all the fields name populated on another menu. After selecting a particular field i want to store the database id of that field in a hidden character field. E.g. Menu1->MyApp:Form1 Menu2->Form1:Fieldname zcharfield->databaseid of fieldname selected in menu2. Environment: ARS 6.3 SQL 2000 Server So how do i retrieve the databaseid of the fieldname selected? Kindly help!! Regards, Veeral Oza The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __20060125___This posting was submitted with HTML in it___