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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement