>in some cases I have 20 users on the same table.
>
>anyway as for the replace in one command, it originally was, I modified it due to a specific issue, a quick fix as it were. however I think I will modify it to the insert as people are saying it has less incidence.
>
>Thanks for the info
Don't forget the FLUSH :-)
I remeber when I used CLIPPER and work undex NOVEL (3.14 if I remeber well) I always have to use COMMIT, so all the changes to be writen on disk, if I forgot to use it sometimes I have lost data.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.