Re: Retrieve database info using active link

[parikshit saxena]

**

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. 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___