>>>What is the syntax for the view ?
>>
>>The view was created interactively. It is a very simple view, based on a single table. The SQL it generates is:
>>
>>
>>SELECT *;
>> FROM database!plandet;
>> WHERE Plandet.plan = ?tnPlan
>>
>>
>>In addition, one of the fields (under "Properties") has a default value that calls a UDF: serialnumber("plandet")
>>
>>In Update Criteria, all fields are updateable, one field is defined as the primary key.
>>
>>That's about it. The view used to work. I suspect it has simply been corrupted, and suggested my contact to re-create it from scratch. I haven't heard back from him about that yet.
>
>I think it may be the SerialNumber function causing the problems. Is it referenced in the whole view code by any chance? Can you remove it and see, if the error will be gone?
This is used in many different views. Anyway, I'll suggest seeing what happens when it is taken away.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)