I did an custom action bpm and added a checkbox ud04.checkboxxx to the baq so the row would be changed.
Greg
/* Delete UD04 */
For Each ttResults where ttResults.RowMod <> '' on error undo, next:
For each UD04 where UD04.Company = cur-comp and UD04.SysRowID = ttResults.UD04_SysRowID exclusive-lock.
Delete UD04.
End.
End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 19, 2015 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Delete Record using Updatable Query
Good Morning,
I have an updatable query / dashboard. I have ability to add and edit records working, however, I can't figure out how to allow deletion. It's a UD table, so the dashboard is just providing my primary system interface to the data.
Has anyone used an updatable query to delete records? Can you please share suggested way to do it?
Thanks
Nancy
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."