Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow vfp
Message
From
18/11/2006 11:33:23
 
 
To
18/11/2006 06:26:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01170532
Message ID:
01170983
Views:
8
>>Hello guys!!!!
>>i have a 1.5 GB table in shared mode. can anybody tell me why in the H*** the first time I run "SET FILTER TO .F. " it takes 5 minutes? should i use somekind of buffering that i don't know?? would it help?
>>
>>thanks,
>>ionut
>
>Simpliest solution (after reaing others):
>
>recordsource = "".
>
>Second is Gordon's:
>
>set key to -1 && if an order is available and lowest possible value is 0
>
>
>Cetin


Hello Cetin,

I thought about the recordsource = '' but thought that it would blow away the grid structure/design when reset to something.

e.g.

recordsource = ''
recordsource = 'myCursor'

Would this not mess up the controlsources on each of the columns if they were added manually? Or would it blow away the columns altogether?

I haven't tested this yet. Nor can I remember what would happen.

Gordon.
Gordon de Rouyan
DC&G Consulting
Edmonton, Alberta
Email: derouyag@shaw.ca
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform