General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Perhaps you have a clash with another of your field names
do you get the same result if you use clInv instead of INV as your variable name.
Also check for .null. being returned
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only