No, SQL is pretty much SELECT, INSERT, UPDATE, DELETE. As for execute you may find the short version of EXEC is used more often than EXECUTE (As a rule we programmers like to abbreviate ;) or use a lot of TLA )
You probably want to do the same on the filter side If you have the "Record Object Relationships" option turned on (in the AR System Administration Console) you can do the searching inside of Developer Studio and find the keywords as well. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of MalviyaSaurabh Sent: Monday, June 15, 2015 9:20 AM To: [email protected] Subject: Re: Set field SQL statement correction Hi All, I used ArInside utility to document the ARS. And actlivelinks with DirectSQL was pretty easy to find out from the documented output of arinside. Though I am finding it tough to identity activelinks which has set field action with Datasource as SQL from the document. I have come up with a query for actlivelinks like below: select a.name,a.actlinkid,b.actlinkid,b.assignshort,b.assignlong from actlink a ,actlink_set b where a.actlinkid = b.actlinkid and ( lower(b.assignshort) like '%select%' or lower(b.assignlong) like '%select%' or lower(b.assignshort) like '%update%' or lower(b.assignlong) like '%update%' or lower(b.assignshort) like '%delete%' or lower(b.assignlong) like '%delete%' or lower(b.assignshort) like '%insert%' or lower(b.assignlong) like '%insert%'or lower(b.assignshort) like '%execute%' or lower(b.assignlong) like '%execute%' ) Am i missing any other db keyword from the qualification? More easy would be if I get to know where Datasource as SQL is stored in actlink_set table. Regards, Saurabh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
