Hello All,
A real basic question, but help is needed !!!

How to I do a display session based on the below script ??

"select field1,field2,field3..... From tdpur045 where tdpur045.quap=0 and tdpur045.spur=5 "

Display should be a drop down listing i.e

Field1 Field2 Field3
------ ------ ------
1 ABC PQR
2 EGF XYZ


I have used the standard "Generate Session" to do a Display Session but the output is a display of the entire table. The script thus generated does not give me the option to add "Where " condition.

Any help is most welcome

Hello vincent,

how about use of query extension?

you use it in the before.program section of your program script.

syntax is like:

query.extension = "tdpur045.quap = 0 and tdpur045.spur =5"

and the fields you want to display you must select when you generate your session with "selecting and ordering fields" in the options menu.

hope it helps

regards

asterix