Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 OLEDB error when posting duplicate record to Frontpage 2k to SQL 7

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-25 : 10:40:49
carter writes "I have a frontpage 2000 form that posts information to a SQL 7 Database. The table I am posting to contains a record that does not allow no duplicates (unique Key).

When I post a duplicate record, An OLEDB error message appears. How and where can I code a statement in Frontpage where if a duplicate record exists when posting the form users will see a page that says something like "you've entered a duplicate record, click here to go back and change your information (with possible alternatives)"?

Carter"
   

- Advertisement -