Bob, Make a view form that you can do an equivalent search to your "SQL query".
Then you could: Create a table field that searches this view form with the correct search conditions. Use an active link loop over the table and for every row push a new record to the target form. OR you could: Do a push to modify all matching rows in the view. Then have filters on the view form do a push to the target form. NOTE: ARS is not a "set based language". It is "single record" tranactional in nature. Even the Push to "Modify All" really processes each record one by one. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 9/28/06, Halstead, Robert <[EMAIL PROTECTED]> wrote:
** I would like to handle multiple results from a sql query in remedy. The query I want to run may return multiple results in which I would like to push each result to a form. Is this possible? Bob Halstead __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
