FIX: GPF or Crash When Indexing a Long Numeric CalculationID: Q107397 2.00 2.50 2.50a | 2.50 2.50a MS-DOS | WINDOWS kbprg kbfixlist kbbuglist The information in this article applies to:
SYMPTOMSIndexing 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. STATUSMicrosoft 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 INFORMATIONSteps to Reproduce Problem1. 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)) 2. 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 Additional reference words: FoxDos FoxWin buglist2.50 buglist2.50a fixlist2.50b 2.0 2.50 2.50a buglist2.50a fixlist2.50b gpf crash KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: FxprgGeneral Keywords : FxprgGeneral kbbuglist kbfixlist Version : 2.00 2.50 2.50a | 2.50 2.50a Platform : MS-DOS WINDOWS Solution Type : kbfix |
Last Reviewed: October 16, 1997 |