FIX: SQL with a UDF Causes "Invalid Subscript Reference"ID: Q105504 2.50 | 2.50 WINDOWS | MS-DOS kbprg kbfixlist kbbuglist kberrmsg The information in this article applies to:
SYMPTOMSA Structured Query Language (SQL) SELECT command that uses a user-defined function (UDF) causes the following error: Invalid subscript reference. STATUSMicrosoft has confirmed this to be a problem in FoxPro 2.5 for MS-DOS and FoxPro 2.5 for Windows. This problem was corrected in FoxPro 2.5a for MS-DOS and FoxPro 2.5a for Windows. MORE INFORMATIONSteps to Reproduce ProblemCreate and run a program with the following code: CREATE TABLE equip (equipment C(6)) INSERT INTO equip (equipment) VALUES ; ('PHONE') CREATE TABLE timeitem (worksys C(10), jobnum C(9)) INSERT INTO timeitem (worksys, jobnum) VALUES ; ('PAGER', '1') SELECT ti.worksys, ti.jobnum, eq.equipment ; FROM timeitem ti, equip eq ; INTO CURSOR testcur ; WHERE eq.equipment = whichval(ti.jobnum,ti.worksys) PROCEDURE whichval PARAMETERS jobnumval, worksysval IF EMPTY(jobnumval) RETURN worksysval ELSE RETURN "job" ENDIF The following program error is generated: Invalid subscript reference. The following message is the expected result: Selected 0 records in <x> seconds Additional reference words: FoxDos FoxWin 2.50 buglist2.50 fixlist2.50a errmsg err msg KBCategory: kbprg kbfixlist kbbuglist kberrmsg KBSubcategory: FxprgSql Solution Type : kbfix |
Last Reviewed: October 14, 1997 |