Thanks for all the responses. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:12 AM To: [email protected] Subject: Re: SQL Form?
Sorry, here is the export with the accompanying active links. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -----Original Message----- From: Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:08 AM To: '[email protected]' Subject: RE: SQL Form? Here is the one I use. It's pretty basic. It checks for DROP, Drop, or drop in the sql statement. I've also added clear buttons for the sql query field, and for the result field. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:01 AM To: [email protected] Subject: Re: SQL Form? It's not a BMC/Remedy product - someone wrote it and posted it to the old Remedy Community site - it was there for a very long time. Granted - it is pretty easy to write one. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 9:57 AM To: [email protected] Subject: Re: SQL Form? I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: [email protected] Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of it....might have to bump that up a few notches... ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: [email protected] Subject: Re: SQL Form? ** What's the SQL form? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: [email protected] Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find it....which could just be a case of the Mondays.... William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
