preprocessor problem

[tommyj77pl]

Hi all,
I would like to create application when user enter query in the input box on the page, press ok and then is able to see the result of the query in browser. I have a code like below

output-content-type("text/html").

&SCOPED-DEFINE test pt_mstr
&SCOPED-DEFINE test4 pt_prod_line

FOR EACH {&test} no-lock.
{&out} {&test4} .

end.

But how can I make something like

&SCOPED-DEFINE test get-value("selected_db") ???

Thanx

 

[jongpau]

Hi,

Preprocessors get parsed when you compile your code. This means that really they are only a way to replace or change bits and pieces of code at compile time. If you want to use "variable" table and/or field names you will have to start using dynamic queries. It may be worth looking those up in your Progress/OperEdge documentation

Paul