problem in screen painter

[Former Member]

hello,

i am working on screen painter and have some problems with it.

i have created a form in which there is an input/output field 'list1',

when i enter the value in the field, and then press the 'display' button,

then the next screen is called. the next screen has a lot of drop down boxes .

what i want to do is, the value dat i enter is a primary key value from a table, and on the next screen

i want the corresponding field values to be displayed in res drop down box...

the table is a transparant table...

plz help me out...

eg. in screen 100 there is an input/output field 'PROJECT_NAME' and DISPLAY button,

in screen 200 there are 3 drop down box, PROJECT_ORIGINATOR, PROJECT_TYPE and

PROJECT_ASSIGNED TO.

if i enter project_name as 'xxx' and then press the 'DISPLAY RESULT' button , then screen 200

is called.. i want all the information about project from the transparant table PROJECT_INFO in

the res field...

[Former Member]

Hi,

In Screen Programming Values are passed between screen if they have same screen names,

So Both the screens name should be same and reference to dictionary object.

If the screen field has paraameter Id assigned to it In the Properties Windows of the label enter the Parameter id and Check SPA & GPA.

Parameter ID you can get from DATA ELEMENT LEVEL-->Further Charactersitis.

Regards,

Gurpreet

[Former Member]

Hi,

For those fields of the second screen ---

1) Double click field a screen will be appearing on the right side then

2) Atributes Dict . and check the checkboxes of Set parameter and Get Parameter .

You will be getting those fields filled -up automatically.

Regards

Pinaki

[Former Member]

Hi,

If both screens are in the same program then ,

in the PBO of the screen 200 write the select query and fill the screen fields with those values like

PROJECT_ORIGINATOR etc. for the particular 'PROJECT_NAME'.

Regards,

Manoj Kumar P

[Former Member]

Hi

In your program you must declare a variable having same name as your screen field name ie. 'PROJECT_NAME' . Now when you enter the value in screen, it gets stored in this variable in your program. Now when you call the new screen when button is pressed, then in the PBO of screen 200 you must write a select query to retrieve the values from the table and store them in variables having names PROJECT_ORIGINATOR, PROJECT_TYPE and PROJECT_ASSIGNED TO. Now automatically your values will be displayed on screen 200.

Hope this helps

Regards,

Jayanthi.K