Posted by Steve on 10/17/06 21:13

".:[ ikciu ]:." <no@mail.com> wrote in message
news:eh3feq$vd5$1@news.dialog.net.pl...
| Hmm Breklin <breklin@sbcglobal.net> wrote:
| > Run a select statement using some identifiable value in your form to
| > check for duplicates. Perhaps the Name of the item or your product
| > code, etc.
|
| NOPE, why no1 trust me?

because you have your head up your ass. it may be that you just don't
understand english. in fact, i'll give you that as the benefit of the doubt!
THAT'S why you don't understand ANYTHING being said here...it's NOT that
you're totally brain-dead!

| make filed unique in db,
| id is not importan - use autoincrement
| on duplicate entry make error handler fo it and just do what you want
|
| THIS IS THE BEST SOLUTION


not even close to ANY solutions. as i pointed out, multiple submits will
generate duplicates and an autoincrementing id does nothing to prevent data
overwrites. this is based on not ONLY an autoincrementing id but
particularly based on a product code/id.

but again, benefit of the doubt...idiot.

[Back to original message]