Information générale
Titre:
Question on sending multi-table view changes to base table
i have a view that combines data from two vfp tables.
the tables are related through a foreign key and the fk's are
used as the inner join condition between the tables. here is
how my code looks...
create sql view MYVIEW ;
as select ;
TABLE1.PK , ;
TABLE1.FK , ;
TABLE1.COLUMN1 , ;
TABLE1.COLUMN2 , ;
TABLE1.COLUMN3 , ;
TABLE2.COLUMN1 , ;
from TABLE1 ;
inner join TABLE2 ;
on TABLE2.FK = TABLE2.PK
i displayed the rows from the view in a grid.
i can edit TABLE1.COLUMN2, TABLE1.COLUMN2, TABLE1.COLUMN3 and
successfully update the base table. when i edit TABLE2.COLUMN1 the
tableupdate fails.
i have tried different combinations of dbsetprop and cursorsetprop
calls to set the tables and fields that can be updated but i have not
had any luck.
thanks in advance for any insight on this...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement