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,
Bill Armbrecht
VFP MCP