If you're on SQL Server, then you could use 'openrowset' to get at the data on the remote server in a query from your destination system. You can find the details on this at: http://www.databasejournal.com/features/mssql/article.php/10894_3331881_1
Since it is a query, you can create a view from it. I would not recommend this normally (because it is - IMHO - kludgy), but if it is for a one time update and you make sure to drop the view after the fact, it should work. Once you have the view in place, create the vendor form and add the workflow onto it... > It be easy if everything was in a form. lol Sadly, the data that I need > is in another database and that is the problem. The Push Fields doesn't > handle SQL at all. If it did, it would be easier then. I've tried > throwing some sql into the Push Fields "push if" qualification and it > gave me a relational error and the sql was valid. I guess I'll just have > to handle one at a time. > > Thanks though Carey =) > > > Bob Halstead > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black > Sent: Friday, September 29, 2006 7:07 AM > To: [email protected] > Subject: Re: Database results > > 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 > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
