Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate View Names in the DBC
Message
From
26/04/2001 16:52:10
 
 
To
26/04/2001 16:26:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00500375
Message ID:
00500393
Views:
24
>Unfortunately I have encountered a situation where a customers data has 2 views with the same name. When my reindex code runs it also packs the DBC where it faults causing the DBC to become completely corrupt as if it was not already.
>
>has anyone encountered this problem before... and if so....how are 2 views with the same name in the DBC.
>
>Thanks in advance

The only way I can think that 2 (or more) views with the same name could get into the database is that the DBC was USEd and records were RECALLed.
When you re-create a view, the existing view is deleted and the new one is added. Since the DBC is a table, these records are still there, just marked for deletion.
Any code, or over-ambitious user or developer <g>, USE the DBC?
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform