>> Where is the best embed point to get the values of the record being loaded before any amendments take place?
PreUpdate routine
(also PreInsert and PreCopy and PreDelete depending on what you need.)
hint: There's a method called FileToSessionQueue that may come in handy here. This basically pushes all the file fields into session values _with_ the opportunity to set a "prefix" on the fields. So, in other words, in the embed point your code would just be one line;
p_web.FileToSessionQueue(Customers,false,'HIS')
so Cus:Name would be pushed into the Session queue as HISCus:Name
The first parameter is the file name, the second pushes the field into the Value queue as well (not needed for you in this case), and the third is the Prefix. Prefixes can be up to 5 characters long.
(hint - don't use _old_ - that's already used by me.)
um - well actually if you don't embed any code in the updates at all, chances are
p_web.GSV('_old_cus:Name')
returns what you are looking for. (But test that.)
Cheers
Bruce
Cheers
Bruce