Re: modifications on a query

Maciej Wisniowski <[email protected]>
Newsgroups gmane.comp.web.zope.database
Message-ID <[email protected]>
> I use zope2.9.4 with postgresql8.1, in my database i have some tables
> are the result  of a query on other tables.
> exe: table1 is the result of table2 with table3
>
> My user can connect to the database and he can modify the  table1,
> this modification should done on the orginals tables table2 and table3
>  my  problem is how  i can  specify the origin of the column in table
> for verifing that table2 and table3 may this modifications?
>
> thanks for all suggetions.
Is table1 a view?
What does 'table2 with table3' mean?
If you have SQL statement like:

select col1, col2, col3 from ....

then you know where columns come from... don't you?

-- 
Maciej Wisniowski
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.