>>>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
>