Eli_Vingot
May 2nd, 1999, 06:43 AM
Hi,
In my program I sometimes connect to ODBC databases using DAO.
At times I try to do operations that will cause an exception, like try to add a record that cause a duplicate primary key.
The problem is that all the information DAO gives me is “ODBC – Failed” (when trapping DaoExceptions)
I noticed that when using ODBC I can get a real useful error message (like: “Violation of PRIMARY KEY constraint 'UPKCL_auidind': Attempt to insert duplicate key in object 'authors'.")
Is there a way to get this error message when using DAO?
Thanks,
Eli
In my program I sometimes connect to ODBC databases using DAO.
At times I try to do operations that will cause an exception, like try to add a record that cause a duplicate primary key.
The problem is that all the information DAO gives me is “ODBC – Failed” (when trapping DaoExceptions)
I noticed that when using ODBC I can get a real useful error message (like: “Violation of PRIMARY KEY constraint 'UPKCL_auidind': Attempt to insert duplicate key in object 'authors'.")
Is there a way to get this error message when using DAO?
Thanks,
Eli