Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hilmar,
>I also found (VFP 3) that the RI sometimes fails, and selects the wrong table. I had one table called "Article", another called "ArticleSupplier" (or something similar - it was quite a while ago). Note that "Article" $ "ArticleSupplier". In this case, RI might already have opened "ArticleSupplier", and decide to check there, instead of opening "Article"!
That's a good one! However, if I look at the VFP RI code, the mixup would occur between "ArticleSupplier" and "Supplier". This has to do with the manner of how it remembers which tables are opened by the RI builder. I checked my RI code, and saw that here the same problem might exist. I'll take inmediate action to solve the problem.
Thanks in pointing out.
>It required some hours of tricky debugging to pinpoint the problem. I decided to avoid such situations in table names (currently, in another system, I have an "Article" table too - but it is now named "ArticleMain", to bypass the problem). I didn't investigate whether the problem was solved in later versions of VFP.
If I look at the VFP RI code, the same problem is still in it today.
Thanks again,
Walter,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement