Thanks James, That was the problem, I just installed the newest updates and it worked
________________________________ From: James Bentley <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, February 24, 2009 11:08:29 PM Subject: [RBASE-L] - Re: Format question TOM HART wrote: > 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 > Tom, What version is your compiled application? The availability of "NN" for formatting #NOW only appeared with the latest update or the one previous to that. Previous to that you got errors when you tried to format #NOW. As an alternative pending resolution of your problem consider the following: set var tvcustrans = (.vEmpID + FORMAT(.#DATE,'MMDDYY') + + FORMAT(.#TIME,'HHMMSS')) The above uses previously undocumented syntax to format DATE and TIME items. Jim Bentley American Celiac Society
