Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use logical indexes into RI
Message
From
19/07/2006 07:04:19
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
19/07/2006 02:25:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137500
Message ID:
01137538
Views:
17
>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,

Isn't 3rd table is all you need? The other 2 just looks like redundant data.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform