topic-14788

Board index FiveWin for Harbour/xHarbour How to create index with ADSCDX?

Posts: 92

Joined: Thu Feb 15, 2007 11:37 AM

How to create index with ADSCDX?
Posted: Tue Mar 03, 2009 12:48 PM

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

Table

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

Index On

Code (fw): Select all Collapse

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

FiveWin 9.03 + xHarbour !!

Patricio Avalos Aguirre

Posts: 1074

Joined: Fri Oct 07, 2005 01:56 PM

Re: How to create index with ADSCDX?
Posted: Tue Mar 03, 2009 01:40 PM

Hello

Code (fw): Select all Collapse

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

Saludos
Patricio

__________________________________________________________________
Version: Harbour 3.2.0dev (r1307082134),Compiler: Borland C++ 5.8.2 (32-bit)
PCode version: 0.3, FWH 13.2
http://www.sialm.cl

Anderson.OL

Posts: 92

Joined: Thu Feb 15, 2007 11:37 AM

Re: How to create index with ADSCDX?
Posted: Tue Mar 03, 2009 01:56 PM

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

Revised.
it is not this.

FiveWin 9.03 + xHarbour !!

FiveTech Support Forums

Continue the discussion