I have a form and in an on before start I generate a variable tvCustrans I have been doing it this way set var tvCustrans = (.vEmpID+(ctxt(iday(.#now)))+(ctxt(imon(.#now)))+(ctxt(iyr(.#now)))+ +(ctxt(ihr(.#now)))+(ctxt(imin(.#now)))+(ctxt(isec(.#now)))) this is a unique number that is inserted into a table, this works fine with no problems for over a year
recently I experimented with the format to generate the same number like this set var tvCustrans = (.vEmpID+(format(.#now,'MMDDYYHHNNSS'))) this will work running it from Rbase but if I try to run it from a compiled app I get the message saying the number must be unique. In my app that is the only change I have made. Just wondering what is happening
