Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: Index with Currency Constant on TableBuffer Cursor
Message
De
24/06/2003 09:30:07
 
 
À
23/06/2003 07:26:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00802831
Message ID:
00803258
Vues:
16
Thanks for bringing this to our attention.

I submitted it on your behalf. Note that this behavior is not new to VFP8, I see it in all VFP versions, back to VFP3.

>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
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform