Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can a Table Buffered View be index
Message
 
To
06/11/2007 14:27:33
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01267052
Message ID:
01267083
Views:
16
>>>>>Hi all
>>>>>
>>>>>Can Remote Views with Table Buffering be indexed? The index does not have to be a CDX as it is only for temporary purposes.
>>>>>
>>>>>Please advise.
>>>>
>>>>As Dragan suggested:
>>>>
>>>>*** In INIT event of the form (or anywhere BEFORE you made any changes to the View)
>>>>SELECT YourViewAlias
>>>>CURSORSETPROP([Buffering], 3, [YourViewAlias])
>>>>INDEX ON ..... TAG ...
>>>>CURSORSETPROP([Buffering], 5, [YourViewAlias])
>>>>
>>>
>>>OK, I beat you by 90 seconds - during which you had the time to refresh UT and read my message? Or did you read it later and update yours? :)
>>
>>No, I read your message and then post mine :-)
>
>OK, I'm waiting for a phone call. What's your excuse? :)
>
>>Just as an example to your, for these pepoles (did I need to change this according to thread #1266935 :-)) who didn't know how to change buffering mode.

A beer? (many of it?)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform