Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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,
Previous
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