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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only