>>>The IIF() in your view definition is causing the structure of the resulting cursor to vary with the results. VFP decides on the structure of a view cursor based on the results of the query that defines it. If during one REQUERY(), the results cause a different field width then on the previous REQUERY(), you'll get the error that you got.
>>
>>OK, if that's the problem, I can probably fix it. I'd really like to know why this code was working fine until yesterday!
>
>This kind of error can vary with the data in your tables. Obviously, depending on the data returned, the results might be heterogeneous enough to never cause a problem.
Sorry, that should read HOMOgeneous enough to never cause a problem.
Erik Moore
Clientelligence