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 <nti...@umich.edu> 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"
