Programming with dBASE - BDE Error 9729 / Key Violation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

BDE Error 9729 / Key Violation

Paul Van House

2005-06-22, 1:23 pm

Occasionally in an application I get this BDE Error/message (9729 -
Key Violation) when trying to open a Progress table through ODBC. The
error box that opens during program execution just displays
[MERANT][ODBC PROGRESS driver][PROGRESS]SYSTEM ERROR: Open Interface
Driver protocol error during dsqldynprep. (2577)

The code that causes the error is setting the query object's
"Active" property to True.

If I quit the application then re-enter all is well for a while...

"Key Violation" normally means there are duplicate entries in a
primary key but I am not trying to save anything or open an index...just
trying to open the table.

Any thoughts?

--
Paul Van House
(remove _removeme_ from mail address for e-mail replies)
Radio/TV software and baseball statistics software:
http://www.binxsoftware.com
Family Home Page: http://www.binxsoftware.com/vanhouse
Church Home Page: http://www.ashfordumc.org

Sponsored Links