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"
