Karen,
My fault for not mentioning that the ID is a text field. It is a combination of the date, the state and any integer 1 to 99. I have gotten the quoteID to change to the desired ID, now I am working on the calculations so I may have another question. We will see. Jim ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, December 07, 2008 1:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Duplicating rows Jim: The "format" command only works on TEXT variables, I believe, and your vQuoteCount is still an integer. You'd have to put a CTXT(.vQuoteCount) in there or change it to a text type before this. Karen SET VAR vquoteID = + ((TRIM(FORMAT(.#DATE,'MMDDYY')))+(TRIM(FORMAT(.vQuoteCount,'00')))+.vShi pToState) IF quoteid <>.vquoteid THEN UPDATE tquoteheader SET QuoteID = .vquoteid UPDATE tquotedetail SET QuoteID = .vquoteid ENDIF Two errors are occurring that I cannot figure out. One is the SELECT COUNT is not adding a '2' to the new ID number. The ID in the Header is already (in this case) 120701IA so the new number should be 120702IA. That is not happening.
