Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening Table in DE
Message
 
 
To
05/06/2008 10:24:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01321865
Message ID:
01321888
Views:
13
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--
Previous
Reply
Map
View

Click here to load this message in the networking platform