Re: RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Maciej Wisniowski
> any suggestions? Write a procedure in the database that does this and just call this procedure from Zope. -- Maciej Wisniowski ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db

Re: RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Charlie Clark
Am 26.01.2007, 14:17 Uhr, schrieb Graziella Toutoungis <[EMAIL PROTECTED]>: curs.execute("DROP TABLE test_fetch") #curs.execute(createQuery) i will integrate in zope this code to create a form in order to give the users the capability to manage my database. any suggestions? Yes, you

RE : Re: [Zope-DB] modifications on a query

2007-01-26 Thread Graziella Toutoungis
in my database i want to create a table1 who is the result of a query on table2 and table3 like select x2,y2,x3,y3 from table2 and table3... -i want now to create the table1. -evrey time the user try to insert into table1, i must insert this data in the original table and verify the possibility of

Re: [Zope-DB] modifications on a query

2007-01-26 Thread Charlie Clark
Am 26.01.2007, 08:37 Uhr, schrieb Graziella Toutoungis <[EMAIL PROTECTED]>: Hello, 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 ca

Re: [Zope-DB] modifications on a query

2007-01-26 Thread Maciej Wisniowski
> 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 tabl

Re: [Zope-DB] modifications on a query

2007-01-25 Thread Andreas Jung
--On 26. Januar 2007 07:37:25 + Graziella Toutoungis <[EMAIL PROTECTED]> wrote: Hello, 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 databas

[Zope-DB] modifications on a query

2007-01-25 Thread Graziella Toutoungis
Hello, 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 tabl