>I am using vfp5 front end with a vfp back end database. Not a sql database.
Oops!, sorry, I thought you were using SQL.
With a VFP back end, things are a little bit easier, though. You can see the code that VFP "triggers" when you delete a record. Just issue:
OPEN DATABASE mydbc
MODI DATA
Right click on the "gray" area and select "Edit Stored Procedures"
You will see a lot of procedures, but basically there will be a procedure for each operation (DELETE, INSERT, UPDATE) for each table. In other words, three procedures per table. I don't remember the names, but you should be able to figure out the puzzle inside of it. It is plain fox pro code. You can modify it, add a SET STEP ON and debug it.
>Hey Hector,
>
>I found one instance of this error by using the gaerrors() array.
>It told me the child dbf that was missing from the database.
>
>but, in other instances it does not populate the array so I have no idea
>what is causing it.
>
>I am using vfp5 front end with a vfp back end database. Not a sql database.
>so, i have limited tools to find out info about the error.
>From what I can tell from RI builder is when you issue 'delete from ???'
>in parent table it opens up all child dbfs in their respective work areas
>and then scans each table while relational field or expression is true
>and deletes the records associated with parent dbf. So, anyway to
>trap this or write a little fxp to catch it?
>thanks,
>
>ronnie
Hector Correa