See if data already exist DBEdit

[heydyrtt]

Have DBEdit box which is linked to datasource field ssn. When entering a new person on this form, if they already exist I do not want duplicate record, so after entering a ssn number in DBEdit and onexit I need to check and see if that ssn is already in the table, how do you do this?


Thanks



Heydyrtt

 

[2ffat]

Off the top of me head I can think of a couple of ways. One is to have an index on SSN. You can then do a search on the SSN to see if it exists. I suppose you wouldn't have to have an index but it would be faster if you did.

Another is to tell the DB to disallow dups. When you post to the DB, you can use a try...catch statement. The catch statement could catch dbErrors for dup SSNs.

What DB are you using? How you handle this may depend on your DB.



James P. Cottingham

^{There's no place like 127.0.0.1.
There's no place like 127.0.0.1.}