Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opening Table in DE
Message
 
 
À
05/06/2008 10:24:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01321865
Message ID:
01321888
Vues:
14
If AutoOpenTables property of DE is set to .T. (default) tables, views, etc included in DE will be open when DE is instantiated.

>
>Can anyone fill me in on this - I have a form where I open a table in the DE and set the buffering to zero. I did this so that I do not have to make sure that the table is open anywhere else in the life of the form. But I was having trouble when debugging something else and I error code that seemed to make me think that when a table is included in the DE, that VFP does an implicit open of it as if it were a view. e.g.
>
>Table name: quotes.dbf
>Buffering: 0
>
>I saw this code flash by when debugging:
>
>
>
>SELECT * FROM Quotes INTO CURSOR <generated cursor name>
>
>
>
>I do not have a view in the DE that is even remotely close to that so I am wondering if the DE is opening the table like a view. If so, that is going to take a lot longer than just opening the table via code.
>
>Thanks,
>Albert
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform