Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening Table in DE
Message
From
05/06/2008 10:24:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Opening Table in DE
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01321865
Message ID:
01321865
Views:
62
Hi all,

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
Next
Reply
Map
View

Click here to load this message in the networking platform