General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to use logical indexes into RI
Environment versions
Network:
Windows 2003 Server
I have three .dbf named dcountry1, dstate1, ddistrict1
1.
table: dcountry1.dbf
fields: country
index: country candidate
2.
table: dstate1.dbf
fields: state, country
index: country+state candidate
country regular
3.
table: ddistrict1.dbf
fields: district, state, country
index: country+state+district candidate
country+state regular
Set Relation:
1. country(dcountry1.dbf) into country(dstate1.dbf)
2. country+state(dstate1.dbf) into country+state(ddistrict1.dbf)
At the time of prepare RI I am getting a message like following:
Cascade updates that are based on expression-based index keys, may not behave as expected. The system has identified expression-based keys in the following relationship;
dstate1 + ddistrict1
Select Ok to continue with RI code generation. (Note: You can override the generated __ri_update_*code by creating stored procedures of the same name, and including those stored procedures AFTER the end of the generated RI code.
I would like to know how to solve the problem. How to set correct RI.
Regards,
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