Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To Keep Index On Remote View ?
Message
De
01/06/2006 04:47:31
 
 
À
31/05/2006 16:59:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01126321
Message ID:
01126399
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
>I can create an index on a remote view, but when I close the view index seems to be lost. How can I reopen the view and its index with it?

You can create a static image of the view, it doesn't support REQUERY()
* create a off line view with a struct cdx
USE dbc!myView
INDEX ON 1  TAG sometag
CREATEOFFLINE('myView',"dbcpath")
For a dynamic image, activate dbc's events:
PROCEDURE dbc_AfterOpenTable(cAliasName)
   DO CASE
     CASE CURSORGETPROP("SourceName") == "MYVIEW"
         IF EMPTY(TAGNO("sometag"))
            INDEX ON 1  TAG sometag
         ELSE
            * REINDEX
            SET ORDER TO sometag
         ENDIF
   ENDCASE
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform