Re: Error -270 when having extra condition in where clause

June Tong wrote: > = > Have you tried turning on SET EXPLAIN? I'll bet it takes different > paths with the added condition. yes, it takes another path because there is also an index with land_kz as first index component. > Have you tried checking for the ISAM > error (in sqlca, I don't remember which field)? It should give you > another error, something like "No disk space" or something like that. i didn=B4t remember the error code. But the error message text of the ISA= M error was "File not found". This seems very strange to me. = We just changed from 4.x developement tools with 5.x server to 7.x tools and server. I will check this query again and see what happens. Greetings, Joerg