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.:
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 wrote:
> 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
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.
That's how I delete columns.
Wrong thread I think!
;-)
Richard
On Tue, Aug 2, 2011 at 7:18 PM, pbreit wrote:
> Navicat Lite or SQLite Manager for Firefox
Navicat Lite or SQLite Manager for Firefox
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 wrote:
> Hello,
>
> If you have a easy way to del
Hello,
If you have a easy way to delete a entire SQLTABLE column before I
find a way, I will take it.
Thanks.
Richard
8 matches
Mail list logo
