>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