>>>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
Check out my alternative to the view designer, eView. you can get it here in the files section, under VFP in general. It allows you to edit views that are too complex for the view designer. I am still working some of the kinks out, but I think its about 98% functional. Try it and see if it solves your view problem
Erik Moore
Clientelligence