Yes...I seem to get more to do than I get done.
________________________________ From: TOM HART <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, February 24, 2009 10:45:50 PM Subject: [RBASE-L] - Re: Format question Hi Gary, guess you saw LJ the other day. It is a text value in both cases ________________________________ From: Gary Wendike <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, February 24, 2009 10:36:59 PM Subject: [RBASE-L] - Re: Format question Tom, just a thought...would the formated value need to be changed to text before combining with empid? This is assuming that the tvCustrans is a text value? ________________________________ From: TOM HART <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, February 24, 2009 10:22:38 PM Subject: [RBASE-L] - Format question 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
