>>>>In an app that has been working happily for many months I am suddenly getting Error 1494 - View definition has changed.
>>>>
>>>>I can open the view in the database and browse it by providing the required input parameter. I have tried deleting the view and recreating it.
>>>>
>>>>It is a very simple view taking only 3 fields and generating 1 cacluated field from a single table.
>>>>
>>>>I am at a loss to see why it will suddenly not work in the app when it works when I access it directly in the dbc.
>>>>
>>>>Any ideas?
>>>>
>>>>Barry Sutton
>>>
>>>
>>>It may be that the properties of your calculated field change depending on the parameter.
>>>
>>>What is the definition of the view - and what is the structure of the table it is built on ?
>>
>>The sql part of the view is:
>>
>>

>>SELECT Plugtrays.id, Plugtrays.pretype, Plugtrays.week,;
>>  Plugtrays.positions*Plugtrays.nosown*Plugtrays.prcnt/100 AS seedlings;
>> FROM ;
>>     production!plugtrays;
>> WHERE  Plugtrays.detl_idno = ( ?v_plandetls.detl_idno );
>> ORDER BY Plugtrays.id
>>

>>
>>Plugtrays.id = C5
>>Plugtrays.pretype = C15
>>Plugtrays.week = C2
>>Plugtrays.positions = N4
>>Plugtrays.nosown = N5
>>Plugtrays.prcnt = N3
>>
>>v_plandetls.detl_idno is provided by the app at run time ; both v_plandetls.detl_idno and Plugtrays.detl_idno are C6.
>>
>>I have rebuilt the view with a completely different name in the dbc and still get the error in the app but not when browsing the view directly.
>>
>>I am beginning to think that the Error message is spurious and in fact there is something else going on....
>>
>>Barry
>
>Try
>You may want to change B(15) depending on the number of decimals you need
>
>
>>

>SELECT Plugtrays.id, Plugtrays.pretype, Plugtrays.week,;
> cast( Plugtrays.positions*Plugtrays.nosown*Plugtrays.prcnt/100 as B(15) ) AS seedlings;
> FROM ;
>     production!plugtrays;
> WHERE  Plugtrays.detl_idno = ( ?v_plandetls.detl_idno );
> ORDER BY Plugtrays.id
>>

Gregory
That worked! Thanks.

But, could you explain why? I can't understand why the CAST function should make a difference.

(It doesn't look like a case of View Definition Changed to me)

Barry