2.00 2.50 2.50a | 2.50 2.50a
MS-DOS | WINDOWS
kbprg kbfixlist kbbuglist
The information in this article applies to:
- Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
- Microsoft FoxPro for Windows, versions 2.5 and 2.5a
SYMPTOMS
Indexing on a numeric expression derived from a long calculation
causes FoxPro for Windows to generate a general protection (GP) fault
and causes FoxPro for MS-DOS to hang and control to be returned to
MS-DOS.
STATUS
Microsoft has confirmed this to be a problem in FoxPro 2.0, 2.5, and
2.5a for MS-DOS and FoxPro 2.5 and 2.5a for Windows. This problem was
corrected in FoxPro 2.5b for MS-DOS and FoxPro 2.5b for Windows.
MORE INFORMATION
Steps to Reproduce Problem
- Create a table containing several 20-character fields of character
type:
CREATE TABLE testtbl (nn1 c(20), nn2 c(20), nn3 c(20), nn4 c(20), ;
nn5 c(20), nn6 c(20), nn7 c(20), nn8 c(20), nn9 c(20), nna c(20), ;
nnb c(20), nnc c(20), nnd c(20), nne c(20), nnf c(20), nng c(20), ;
nnh c(20), nni c(20), nnj c(20), nnk c(20), nnl c(20), nnm c(20), ;
nnn c(20))
- Create a structural index on the sum of the VAL() of the character
fields:
INDEX ON VAL(SUBSTR(NN1,1,20)) + ;
VAL(SUBSTR(NN2,1,20)) + ;
VAL(SUBSTR(NN3,1,20)) + ;
VAL(SUBSTR(NN4,1,20)) + ;
VAL(SUBSTR(NN5,1,20)) + ;
VAL(SUBSTR(NN6,1,20)) + ;
VAL(SUBSTR(NN7,1,20)) + ;
VAL(SUBSTR(NN8,1,20)) + ;
VAL(SUBSTR(NN9,1,20)) + ;
VAL(SUBSTR(NNA,1,20)) + ;
VAL(SUBSTR(NNB,1,20)) + ;
VAL(SUBSTR(NNC,1,20)) + ;
VAL(SUBSTR(NND,1,20)) + ;
VAL(SUBSTR(NNE,1,20)) + ;
VAL(SUBSTR(NNF,1,20)) + ;
VAL(SUBSTR(NNG,1,20)) + ;
VAL(SUBSTR(NNH,1,20)) + ;
VAL(SUBSTR(NNI,1,20)) + ;
VAL(SUBSTR(NNJ,1,20)) + ;
VAL(SUBSTR(NNK,1,20)) + ;
VAL(SUBSTR(NNL,1,20)) + ;
VAL(SUBSTR(NNM,1,20)) + ;
VAL(SUBSTR(NNN,1,20));
TAG rptsort
|