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