>Hi All,
>
>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.
Benoit,
It may have to do with the number of spaces you are using when a null value appears. For example, if you return space(5) for a null, and the actual values of the field are 6 characters then you will get this message. Try padding the nvl() return value with the exact length of the field.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao