Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/107397

From BetaArchive Wiki

FIX: GPF or Crash When Indexing a Long Numeric Calculation

ID: Q107397

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

1. 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
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.