I knew we could use one of these "other" options but none of those are elegant nor would they be instantaneous with updates to the external table (since it's based on when the escalation runs). I just wanted to make sure I wasn't missing something obvious regarding vendor forms.
Thanks for the feedback, Craig Carter, RSP -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Thursday, September 13, 2007 9:14 AM To: [email protected] Subject: Re: Query/Menu from Vendor Form? Create a regular form and populate the regular form from values in the vendor form via escalation. Then build your SQL menu from the regular form. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Thursday, September 13, 2007 9:38 AM To: [email protected] Subject: Re: Query/Menu from Vendor Form? ** Vendor forms are at the software level...not the DB level so you can't do that. You could get inventive and create a regular form, use an escalation to scrape the records of interest out of the vendor form then use either a search or sql menu against the actual table...but not knowing the level of records in question I don't know if that would be feasible. We currently do something similar for web service calls...we make the call...insert the returned records into a table with a unique transaction id and then use those records for a table display... ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Thursday, September 13, 2007 7:59 AM To: [email protected] Subject: Query/Menu from Vendor Form? ** All, Does anyone know if you can perform a SQL query against a vendor form? We have a vendor form pulling back LDAP data and need to build a menu against the form. A standard search menu pulls up duplicate values for the field (office symbol) so we need to perform a distinct query. We can use a SQL menu but I haven't been able to find the vendor form for use with a direct SQL call. The arschema lists it as id 623/type 5 but there is no table or view for this form that I can find (because there really is no table). Anyone know the trick to accessing the vendor form directly via SQL? ARS 6.3 SQL 2000 Craig Carter __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
