How to create index with ADSCDX?

[Anderson.OL]

I created indexes DBFCDX using resulting fields of relationship as below:

Table

Code: Select all  Expand view

PRODUTO            PRODFOR           FORNECEDOR
----------         -------           ----------
ECODIGO   *------* ECODIGO     +---* FCODIGO
EDESCRICAO         FCODIGO *---+     FNOME
 

Index On

Code: Select all  Expand view

select PRODUTO
//-- It creates relationship before indexing
select PRODFOR
DbSetOrder(1)

select ESTOQUE
set relation to ESTOQUE->ECODIGO into PRODFOR

//-- Index with alias
index on EDESCRICAO tag XXX to ("CDXTMP") for PRODFOR->FCODIGO == "0323"
//-- Index without alias
index on EDESCRICAO tag XXX to ("CDXTMP") for FCODIGO == "0323"

The two methods above generate the exception below:

Erro
Application
===========
Path and name: G:\prog\FiveWin\RCA Trade\ADS\RCATRAD@.EXE (32 bits)
Size: 6,361,088 bytes
Time from start: 0 hours 0 mins 10 secs
Error occurred at: 03/03/2009, 09:24:11
Error description: Error ADSCDX/3211 Erro de cria‡Æo: G:\RCA\RCATRAD@\ATUPRPRO

[Patricio Avalos Aguirre]

Hello

Code: Select all  Expand view

3211     Unknown identifier found in conditional index expression
Advantage Error Guide
Problem:  An error occurred in the Advantage Expression Engine parser. An identifier within the conditional index expression is unknown to the parser.

Solution:  This error is usually caused by the use of memory variables within the conditional index expression. Memory variables are not supported by the Advantage Expression Engine as the variables are visible only to the client. This error may also result from a misspelled field name or from a field name that does not exist in the current work area.
 

ademas revisa que este la bd EXCLUSIVE para generar INDEX

[Anderson.OL]

misspelled field name or from a field name that does not exist in the current work area??

Revised.
it is not this.