Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a view
Message
From
21/05/1999 02:40:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Indexing a view
Miscellaneous
Thread ID:
00221265
Message ID:
00221265
Views:
37
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.
Next
Reply
Map
View

Click here to load this message in the networking platform