Hi Bill,

>Hi Benoit,
>>
>>I have a view that is the result of a LEFT JOIN between 2 tables. For some queries, one of the values could be null. Since I do not want null values in my view (view is bound to a grid and this value is bound to a combo in the grid), I am using the NVL function to set null values to empty string.
>>
>>My problem is that when I requery the view with =REQUERY("myTable"), and that the record has a null value, I get an error message "View definition has been changed".
>>
>>Any suggestions to avoid this?
>>
>>Note : I get same message if I use IIF(IsNull(value)) instead of NVL function.
>>
>>TIA.
>
>Do you want to allow updates to the field? If not, and I never have when doing a LEFT OUTER JOIN, be sure the updateable property is .F. for the field. If so, then I don't know.
>HTH,

Unfortunately, the field must be updatable.
Thanks anyway.