Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack a table while used in a grid
Message
From
31/03/1999 11:27:23
 
 
To
31/03/1999 11:20:17
Pascal Binette
Pratt & Whitney Canada
Saint-Hubert, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00203892
Message ID:
00203929
Views:
12
>Because the grid uses this temporary table to display selected customer records from a table. Depending on the number of customers, the table could become very very large. For this reason, I want to pack the database so it stays small.
>
>Also, using a table is the only way i can populate my grid. It is impossible for what i need to do to use a query or sql statement. The only other way that could work is using an array, but i don't think that's possible.

Firstly, what's 'very large' table? If let say you have 1 million records there and you SET DELETED ON, you will still get blazing speed showing it in grid.
Also, usually temporary table means cursor.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform