[Skipper]

Hello,

can someone helb me? I would like to use a SQL query with more than one line as result but the count of lines are dynamic and I want to use it in a grid and in the grid in Textboxes. Do someone know how I can do that? In the Textbox I tried it with the sql query but this doesn't work also when the result has just one line. And likely I don't want to use a trigger before the dynaform. I'd like to have it dynamically in one dynaform, because the where condition of the sql query would be dynamic read in form an select box which is filled by an other query.

Thanks a lot

[amosbatto]

There is no easy way to populate a grid with an SQL query inside a Dynaform. The easiest way to do this is to submit the form, then execute the query in a trigger and then reopen the DynaForm with PMFRedirectToStep(). See:
viewtopic.php?f=44&t=730066&p=812733&hi ... ry#p812666

If you want to limit the number of rows returned by the query add "LIMIT 3" to the end of your query (where 3 is the number of rows you want).