Chandra,

Here is a message I reported to MS via the web regarding similar problem I was having with VFP 7. (I also installed the VFP 8 beta on a test sytem and had the same problem.) I am unsure whether or not this is related to the problem Jeff is having, but it may be a simple starting point. And at any rate it is a problem in VFP 8.

====================
If a database has more than 8 RI links from one primary key to other tables or other keys in one or more tables, and if those links have DELETE actions other than Ignore (i.e. either Cascade or Restrict), then an error occurs when trying to enumerate the stored procedures using OLE DB via VFPOLEDB. If there are 9 links defined, but only 8 have a DELETE action other than Ignore, there is no error. (I have not tested the other RI columns, but mixing 8 DELETE and 1 UPDATE option does not cause a problem.)

The error occurs both with VFP 7 SP1 and with VFP 8 Beta.

This problem with was first discovered using Crystal Reports 9, which bombs out when trying to create an OLE DB link to a VFP database as described above. I have since demonstrated the problem using the QTADO tool downloaded from http://gpoulose.home.att.net/ This tool allows me to test OLE DB links to databases. Using this tool I can explore and query the database fine until I try to enumerate the stored procedures. If I try to enumerate the procedures, I receive an error. Once I enumerate the procedures, I can no longer interact with the database due to errors.

I have reproduced the problem with two different simple test databases. One uses two tables with 9 links from the primary key of one table to nine different non-primary keys in the second table. The other test case uses 10 tables with 9 links from the primary key in one table to a single non-primary key in each of the other 9 tables. All key fields are integer in my tests. There are no other fields in my tables other than one integer primary key field and either nine or one integer non-primary key field in other tables. Setting the RI DELETE to Cascade for any 8 links produces no problem. Setting the 9th link's RI DELETE to CASCADE causes the problem. Resetting the 9th link to IGNORE removes the problem.

My testing was initially done on my development system and subsequently confirmed on a test system with a clean installs of Windows XP Pro SP1 and Windows 2000 Pro SP2, without any other additional software installed.

I would appreciate a fix to this problem as I am unable to use Crystal Reports 9 until this problem is resolved.

...Jim Hansen, Canyon Country Consulting
==========================

I can also e-mail the databases, but they are very easy to reproduce as indicated above.

...Jim