Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Validate Database
Message
De
24/07/2002 09:24:49
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
24/07/2002 07:02:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00681962
Message ID:
00681994
Vues:
14
This message has been marked as the solution to the initial question of the thread.
>Hi
>
>when i make Validate Database Recover , VFP give me error Alias ... is not found .
>But this table is in DataBase .
>And VFP write in screen , Index is rebuilt . DataBase container is valid .
>
>Why i have this error ? It´s bad ? Or can i ignore this ?
>
>Thanks

Pedro,
Table and alias are not the same thing. Probably you've referenced that 'alias' somewhere and alias is not in use. Ignoring it might be very dangerous depending on where you referenced (mostly gone unnoticed till it bites you).

Suppose you've a table named myTable. Antoher table have this index expression (though legal something you should never do) :

index on ID+myTable.ID tag dummy

As soon as VFP can't find the alias it'd error but would continue quoting the expression internally. Using this kind of expression is evil, ignoring it is worse.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform