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
