Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL works when table not in the DE
Message
De
22/02/2005 05:38:51
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00988904
Message ID:
00989159
Vues:
20
>>Just out of curiosity this. I have a form that refers to a table that is neither opened via code nor included in the DE. An SQL select accesses this table and it works OK. Now I know that you don't have to USE ... Select etc a table before it appears in an SQL select generally, but I would have thought the form would need to know exactly where/which table.
>
>In case when table is not open before a query, FoxPro will look for it in the current directory and than along VFP search path (SET("PATH")). The first one found will be open otherwise you'll get Open Table dialog.

Righto, Sergey. Cheers
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform