deleting a particular field values of record before or after saving.
Hi all, Env:ARsystem 7.5 patch4 Database:2005 sql server sp2 I want some tips I don't want some costume field values to be saved before saving they should be deleted.I am trying to use Application-Delete-Entry-$1$-$columnvalue$. It is not working any suggestions for work around. Thanks G -- View this message in context: http://old.nabble.com/deleting-a-particular-field-values-of-record-before-or-after-saving.-tp33539077p33539077.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
Re: deleting a particular field values of record before or after saving.
That’s not the use of Application-Delete-Entry. This run process is used to delete an entry (row) from a table, and not used to set a column to NULL what seems to be what you are attempting.. To set a column value to NULL use the Set Fields action or a Push Fields action depending on which one is more appropriate for your situation, and set that field to the $NULL$ keyword. Joe -Original Message- From: gok's Sent: Tuesday, March 20, 2012 10:17 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: deleting a particular field values of record before or after saving. Hi all, Env:ARsystem 7.5 patch4 Database:2005 sql server sp2 I want some tips I don't want some costume field values to be saved before saving they should be deleted.I am trying to use Application-Delete-Entry-$1$-$columnvalue$. It is not working any suggestions for work around. Thanks G ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: deleting a particular field values of record before or after saving.
Use a set fields action and set those fields to $NULL$. Set field actions are performed before the data is committed to the database. Jason On Mar 20, 2012, at 10:17 AM, gok's gmedise...@yahoo.com wrote: Hi all, Env:ARsystem 7.5 patch4 Database:2005 sql server sp2 I want some tips I don't want some costume field values to be saved before saving they should be deleted.I am trying to use Application-Delete-Entry-$1$-$columnvalue$. It is not working any suggestions for work around. Thanks G -- View this message in context: http://old.nabble.com/deleting-a-particular-field-values-of-record-before-or-after-saving.-tp33539077p33539077.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