Microsoft KB Archive/109583

= PRB: SQL SELECT Causes ICE or "Invalid Function Argument..." =

Article ID: 109583

Article Last Modified on 12/1/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5b for Macintosh

-



This article was previously published under Q109583



SYMPTOMS
The following SQL SELECT statement causes an "Internal Consistency Error" in FoxPro for Windows and FoxPro for MS-DOS. In FoxPro for Macintosh, the SELECT statement causes the error message "Invalid function argument value, type, or count."

This code creates the tables on which to perform the SELECT statement: CREATE TABLE customer ; ( cno C(5), company C(35), contact C(20), ;     address C(30), city C(15), state C(2), zip C(5), ;      phone C(12), ono C(1), ytdpurch N(8,2), lat N(7,4), ;      long N(8,4) )

CREATE TABLE invoices ; ( ino N(4), cno C(5), idate D, itotal N(8), ;     salesman C(3) )

CREATE TABLE detail ; ( ino N(6), cno C(5), LINE N(4), qty N(4), ;     pno C(5), price N(8), ltotal N(8) )

INSERT INTO customer (cno, company, contact, address, ;     city, state, zip, ;      phone, ono, ytdpurch, lat, long) ; VALUES ('a123', '1st Company', 'No Name', 'One Microsoft Way', ;     'Redmond', 'WA', '98052', '1206123456', '1', ;      1000.99, 100.999, 100.999)

INSERT INTO invoices (ino, cno, idate, itotal, salesman) ; VALUES (9999, 'A123', {09/01/93}, 1000.99, 'Bob')

INSERT INTO detail (ino, LINE, qty, pno, price, ltotal) ; VALUES (9999, 1234, 2,'B6722', 27.99, 57.98)

This is the code that produces the error:

SELECT IIF(customer.cno = invoices.cno,SPACE(8),;     one(detail.ino, company, lat)) AS test; FROM customer,invoices,detail; INTO CURSOR two; WHERE customer.cno = invoices.cno; ORDER BY 1

PROCEDURE one PARAMETERS A,B,C RETURN SPACE(8)

Additional query words: VFoxWin FoxMac FoxDos FoxWin iif ice crash errmsg err msg

Keywords: kberrmsg KB109583

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.