Dennis That's the problem, the other columns are not unique. As usual I am doing something unique and most likely bending the rules. We can have several rows with the same Spcode, but different text in the Varchar field. We enter a code then let RBase pick one of the rows at random.
I just redid the code and I think it is working, I am not sure what was wrong before? Thanks Marc From: Dennis McGrath Sent: Friday, June 18, 2010 10:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Append using Varchar The problem is that VARCHAR by its very nature can be huge. For that reason they are difficult to work with. My DISTINCT will not work because VarChars cannot be sorted. Why not test the other three columns (assuming they will uniquely identify the rows)? Dennis McGrath
