>This is usually caused by an IIF in the field list that could return a different length. Make sure you are using PADR (for example) to make sure all the fields in the result set are the same length. The view gets it's definition from the first record in the result set and if any other result has a different length you will get this error.

Thanks - this may actually explain my 1494 that I posted few days ago. I've found I had one field which didn't have a padr() - all the others had. I'll check it, but I think this is what I was having (among other things).