Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a view
Message
De
21/05/1999 02:40:22
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Indexing a view
Divers
Thread ID:
00221265
Message ID:
00221265
Vues:
36
Hi there

I've got this problem when trying to index a remote view:

* first I create a remote view based on the remote table sysref.dbf
CREATE SQL VIEW vwSysRef REMOTE CONNECTION Rem1 SHARE AS ;
SELECT char1,char2 FROM sysref
USE vwSysRef IN 0
SELECT vwSysRef
* then I am trying to index the view
lcOrder = 'CHAR1 + CHAR2'
INDEX ON &lcOrder TO ord.idx
SET ORDER TO ord

I am getting an "Invalid key length" error message (I am using Sybase as back end). I can index this remote view only on CHAR1 (or CHAR2) without any problems.
I can also index the similar local view on both CHAR1 and CHAR2 without any problems at all.
I would really appreciate if someone can help me.
Thank you.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform