>>My form contains a parameterized view which supplies data for the rows of a grid. The grid data are to be read-only. When the form starts, the unwanted message "Edits to view may not be permanent" always comes up. I have tried changing the view with DBSetProp('voucsub', 'View', 'SendUpdates', .F.), but it doesn't help. The view is not accessible from the view designer.
>>
>>Your ideas would be most appreciated.
>
>Why isn't the view accessible from the form designer? What version of VFP?

The version is 5.0. It is not accessible through the view designer, I assume, because it is too complicated. Almost all of my other views cannot be edited for the same reason, which seems to be common among developers on this forum. The code I use to generate the view is:

create sql view voucsub as;
select v.voucher_id, v1.vouc_line_no, v1.sub_id, dr_cr_code, v1.amount, v1.reference_id, v1.description, a.account_name;
from account a, voucher v right join voucitem v1;
on v.voucher_id = v1.voucher_id;
where v1.sub_id = a.sub_id;
and v1.reference_id = shipment.invoice_id;
union;
select v.voucher_id, v1.vouc_line_no, v1.sub_id, dr_cr_code,;
s.amount, s.reference_id, s.description, a.account_name;
from account a, voucher v, voucitem v1 right join subledg s;
on v1.voucher_id + transform(v1.vouc_line_no,'9999');
= s.voucher_id + transform(s.vouc_line_no,'9999');
where v.voucher_id = v1.voucher_id;
and voucher_type = 'GEN';
and v1.sub_id = a.sub_id;
and v1.reference_id = shipment.invoice_id

if not DBSetProp('voucsub', 'View', 'SendUpdates', .F.)
suspend
endif