Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
 
 
To
08/04/2005 15:33:36
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01002645
Message ID:
01002827
Views:
26
>Wow... quite a story, and it seems I guessed a few bits.
>
>Is the code which generates the RI code available? You could then just fix this part - make it generate the right side of the case statements lowercase instead of proper case.
>

Dragan,

Walter's Tax RIBuilder comes as an app, so I don't (!) have the code. And that's weird, since this code is used by lots of people and nobody complained. I think may be my test was too quick and I did something wrong. All I did was downloading Tax RIBuilder, running it against my database, then trying a bad code.

>Also, if this code is available - maybe you could make it less generic, and have it generate specific relation names etc, doing all the aScan()s only once, while generating, not during runtime.
>

Walter's code does it. E.g. it generates code for every table, so in this sense it's similar to the native RI builder, though his code is much more compact and easier to debug. But after I spent so much time working with other code, I don't want to mess in this one.

>I'm saying this as someone who has never had RI code in the database, but has done a lot of generated code.

Here is the original code, you may take a look, if you have time
http://home.twmi.rr.com/ssawyer/content/ricode.htm

Note the link called "here". That's the one I finally took.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform