The program below generates an example of a problem I had with eView: can't set TblC and all of it's fields to be updatable.
create database evt
create table TblA ;
( pkTblA i Primary Key )
create table TblB ;
( pkTblB i Primary Key, ;
fkTblA i references TblA )
create table TblC ;
( pkTblC i Primary Key, ;
fkTblB1 i references TblB, ;
fkTblB2 i references TblB )
create sql view lv_evt as ;
select pkTblA, ;
one.pkTblB, ;
tblc.*, ;
two.pkTblB ;
from TblA ;
join TblB one on pkTbla = one.fkTblA ;
join TblC on one.pkTblB = fkTblb1 ;
join TblB two on two.pkTblB = fkTblB2
DBSetProp("lv_evt", 'View', 'SendUpdates', .t.)
DBSetProp("lv_evt", 'View', 'Tables', 'Tblb')
DBSetProp("lv_evt", 'View', 'WhereType', 1)
DBSetProp("lv_evt.pkTblc", 'Field', 'KeyField', .T.)
use lv_evt
do \foxbin\eview