General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Referential integrity with filter
HI,
I try to build a referential integrity on relation wich on many-side have a filter to limit record indexed - records without values are not indexed. When I try to append record the trigger dosen't allow.
In other words there are an index on 'nrdoc' with filter '.not.empty(nrdoc)' wich is foreign related to primary index 'nrdoc' from 'docs' table with restrict rules. What I try to do is to enforce integrity on records wich have a value to 'nrdoc', other with empty value I want ignored. When append a record wich have empty 'nrdoc' I can't - what are evaluated first index or trigger?
How to do this behaviour? In VFP7 referential procedures are generated with regards of filter expresions on index?
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only