Re: [web2py] delete a SQLTABLE column

2011-08-03 Thread Richard Vézina
Wrong thread I think! ;-) Richard On Tue, Aug 2, 2011 at 7:18 PM, pbreit pbreitenb...@gmail.com wrote: Navicat Lite or SQLite Manager for Firefox

Re: [web2py] delete a SQLTABLE column

2011-08-03 Thread pbreit
That's how I delete columns.

Re: [web2py] delete a SQLTABLE column

2011-08-03 Thread Anthony
I think he wants to delete columns from a SQLTABLE, not a db table. On Wednesday, August 3, 2011 4:01:09 PM UTC-4, pbreit wrote: That's how I delete columns.

Re: [web2py] delete a SQLTABLE column

2011-08-03 Thread Richard Vézina
Yes... I use pgAdmin for the other things, I didn't fix my choice on a commercial database manager... ;-) Richard On Wed, Aug 3, 2011 at 4:04 PM, Anthony abasta...@gmail.com wrote: I think he wants to delete columns from a SQLTABLE, not a db table. On Wednesday, August 3, 2011 4:01:09 PM

Re: [web2py] delete a SQLTABLE column

2011-08-03 Thread Richard Vézina
Don't know if my delete column function could be part of web2py core functions but here it is : def __del_sqltable_column(sqltable, column_name): For deleting a given column in an instance of web2py SQLTABLE class. Pass the SQLTABLE object and the column name to delete. Ex.:

[web2py] delete a SQLTABLE column

2011-08-02 Thread Richard
Hello, If you have a easy way to delete a entire SQLTABLE column before I find a way, I will take it. Thanks. Richard

Re: [web2py] delete a SQLTABLE column

2011-08-02 Thread Richard Vézina
Here I go ;-) rows = db().select(db.table1.ALL) table = SQLTABLE(rows) for i in range(0, len(table[1])): del(table[1][i][0]) del(table[0][0][0]) # Delete the header entry of the deleted column Richard On Tue, Aug 2, 2011 at 2:17 PM, Richard ml.richard.vez...@gmail.com wrote: Hello, If

Re: [web2py] delete a SQLTABLE column

2011-08-02 Thread pbreit
Navicat Lite or SQLite Manager for Firefox