Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: Index with Currency Constant on TableBuffer Cursor
Message
De
23/06/2003 07:26:55
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
BUG: Index with Currency Constant on TableBuffer Cursor
Divers
Thread ID:
00802831
Message ID:
00802831
Vues:
52
Hi,
SET MULTILOCK ON

CREATE CURSOR TestBufferI (A I NULL)
INSERT INTO TestBufferI VALUES(3)
INDEX ON NVL(A,4) TAG IX1
INSERT INTO TestBufferI VALUES(NULL)
=CURSORSETPROP("Buffering",5)


CREATE CURSOR TestBufferC (A C(2) NULL)
INSERT INTO TestBufferC VALUES('33')
INDEX ON NVL(A,'44') TAG IX1
INSERT INTO TestBufferC VALUES(NULL)
=CURSORSETPROP("Buffering",5)

******************

CREATE CURSOR TestBufferY (A Y NULL)
INSERT INTO TestBufferY VALUES($3)
INDEX ON NVL(A,$4) TAG IX1
INSERT INTO TestBufferY VALUES(NULL)
=CURSORSETPROP("Buffering",5)
* NO ERROR ON VFP6SP5
* ERROR ON VFP7SP1 AND VFP8
* "Index does not match the table.
* Delete the index file and re-create the index"

with

INDEX ON $4 TAG IX1 the error appears.
INDEX ON A+$4 TAG IX1 the error appears.
INDEX ON A TAG IX1 the error not appears.
INDEX ON A+NTOM(4) TAG IX1 the error not appears.

The the problem is with currency costant value on index expression.

Fabio
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform