Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SEEK(),INDEXSEEK() or KeyMatch() or SELECT-SQL?
Message
 
 
À
08/04/2005 15:33:36
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01002645
Message ID:
01002827
Vues:
33
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform