Guns come with the same kind of warning, as do most power tools. If used properly, it is a powerful tool; if used irresponsibly, you assume some degree of risk. Even coffee cups come with disclaimers these days. It's the mindset today to protect everyone from themselves. Gone are the days where people evaluate the risk of their actions and take responsibility for their choices.
On Mon, May 7, 2012 at 10:07 AM, Jlbess <[email protected]> wrote: > Yes, running a SQL statement from an active link will update the record > directly at the database level. Just like running a SQL statement from SQL > studio. Bypassing filter execution and system update fields. > The documentation is worded to discourage people from making changes > directly to the ARS database. It's not that you can't, you just run the > risk of destroying your system. > > > Jason > > > > On May 7, 2012, at 10:31 AM, smiley <[email protected]> wrote: > > > I'm looking at the Help documentation about Direct SQL's: (note it says > > 'non-AR' databases... but I need to update an AR database...) > > > > Use the Direct SQL action to submit any legal SQL command to a non-AR > System > > database. Use this command only if it is required for integration with > > another database. > > > > The Direct SQL action has a different result than the SQL command you > use to > > set a field value in the Set Fields action. In the Set Fields action, you > > use SQL to query the database for information and then use the returned > > value to set a field. With the Direct SQL action, the SQL command is not > > expected to return data. For example, you can define a Direct SQL action > to > > perform inserts or updates to a non-AR System database. > > > > > > ------------ > > My issue is that I want to Update a Field Value on a Form, while a user > is > > In that Form, and allow Other Users to see that that value was > updated.... > > Hope that makes sense. > > thanks for any help!!! > > > > > > > > -- > > View this message in context: > http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7535492.html > > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
