Search:

Hi Barry

Just so I am clear on this - I will need to code an OnBeforeDelete trigger for primary table to...

1) If there are child tables which retrict parent deletion then check each of these...

Hi J

The more I think about it RI rules should be handled through the DB independent of the application interface. For example, if I open a primary table and then Browse and then delete a record...

Hi Barry

I have looked further into VFP and I now see that VFP uses Table Relationships and the Referential Integrity Builder to generate internal .prg code for Insert/Update/Delete trigger...

Hi josipradnik (sorry for not knowing your exact name)

We have a primary table which has many child tables. In this case we want to prevent deleting the primary record if there are historical...

Hi Barry

If I wrote this code in the OnBeforeDelete table trigger is this most efficient way to check if a child record exists for a parent key. Of course this code would be repeated for each...

Hi

I am playing with the trial version. I imported a VFP DB to a Lianja DB and now I want to duplicate VFP functionality for the database. The Lianja tables and indexes look fine however there is...