the Problem that i have is the equals Function.
a.name = '1234567'
a.name has a length of 7. (Datatype varchar)
the statement is matching all if i write trim(a.name)='1234567'.
Sorry. We missed to see your post in time.
Maybe there's some spaces before or after your name value.
>a.name has a length of 7. (Datatype varchar)
It's strange. In MS Access, it can store more than 7 character in that column since it can use compression format. But in DBF, it shouldn't happen. You can send us your sample if you think your column length is exact 7, not 8 or other bigger value.
We have an foxpro database (vfp9)and work with your driver to generate an webfrontend.
The column length of 'name' is 7 (VFP data type C(9)) and the column are filled with values of length= 7. The function length() shows 7 for the content length.
I can't send the orginal database because that are personalized data. I make an example database.
Where should I put them out?
I guess that issue was an index issue. Please try to run once "reindex all on a", then your sql will be normal again.