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