Im trying to add a delete method to the inventTable that will run when a Company Specific Product is Deleted. It will check to see if that Product Exist in any other Company and if it does just delete it come the Company Specific table, if it does not delete it from the Global which is the EcoResProduct Table.
Im having a issue with Syntax
if (this.ItemId)
{
While select crossCompany InventTable where this.ItemId && this.dataAreaId == curext()
{
if(?)
{
??
}
delete_from
EcoResProduct
where
EcoResProduct.Recid == this.Product;
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156