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')))+.vShipToState) > > 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. > > > >
