I'm encountering something weird in FPW26.
I tried it in VFP60 and there it works as I expect.
A sipmle SELECT with a filtered subquery.
Like:
select * from
where IN (select from where inactive)
Where as Inactive is a field of type logical.
In the contrary to my expectations I get codes from the that shouldn't be in there due to the filtered subquery.
Here it seems that FoxPro takes the original table instead of the filtered SubQuery, such FoxPro's way of optimizing.
When the query is executed as follows, forcing Fox to create a cursor:
select * from where IN (select from where inactive AND .T.)
I get the expected filtered result set.
Also when doing it like this:
select * from where IN (select from where inactive = .T.)
Anybody a clue if this is a Fox2.6 bug or if it has something to do with a setting we overlooked.
ThanX.