Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Query problem
Miscellaneous
Thread ID:
00454602
Message ID:
00454602
Views:
62
Can someone explain to me why this works:

STOR ALLT(THISFORM.INVNUMB1.VALUE) TO INV
SELECT *;
FROM transactions!factgrostete INNER JOIN transactions!factgros ;
ON Factgrostete.invnumb = Factgros.invnumb;
WHERE Factgrostete.invnumb = "&INV";
INTO CURSOR QUERY1

And this does not:

STOR ALLT(THISFORM.INVNUMB1.VALUE) TO INV
SELECT *;
FROM transactions!factgrostete INNER JOIN transactions!factgros ;
ON Factgrostete.invnumb = Factgros.invnumb;
WHERE Factgrostete.invnumb = INV;
INTO CURSOR QUERY1

Whit this one I get an Operand mismatch. The INV value is character and the invnumb field is character.
Next
Reply
Map
View

Click here to load this message in the networking platform