Hej!
Can someone exlain what's going on here. It looks like a bug to me...
To setup create a table with a memo and add a few records and some empty
records.
create table xxx (xx m(4))
insert into xxx values ('assasa')
insert into xxx values ('a aaa')
insert into xxx values ('')
insert into xxx values ('')
I want this query to return the rows that start with 'a'
select * from xxx where xx='a'
But it returns all rows!!!! Why?
Note:
- SET EXACT has no effect
- happens in VFP 6 and VFP 7
- select * from xxx where xx='a' and not empty(xx) works ok!