LuckieIrie
MIS
I'm using this formula to delete dup entires after creating a new entry. It is supposed to delete entires if they have the same UnitSerialNumber if it is the same as the current document, yet it doesn't work. Can we fix this one? or is there a better way?
@Command([Compose];"IC"
;
list := @DbLookup("Notes"; "NoCache"; "ICView"; "UnitSerialNumber"; "Date"
biggest := @Subset(list; -1) - [01/01/2001 01:01:01 AM];
current := Date - [01/01/2001 01:01:01 AM];
@If(current = biggest; ""; @DeleteDocument);
@All
@Command([Compose];"IC"
;list := @DbLookup("Notes"; "NoCache"; "ICView"; "UnitSerialNumber"; "Date"
;biggest := @Subset(list; -1) - [01/01/2001 01:01:01 AM];
current := Date - [01/01/2001 01:01:01 AM];
@If(current = biggest; ""; @DeleteDocument);
@All