[GRASS-user] Another SQLite - OpenOfficeorg Database issue (for me?)

GRASS GRASS user
1

Is it a limitation of SQLite or OOo DB that I cannot "drop columns" from
within OOo?

I connect witouth any problem to my sqlite.db, can retrieve the database
and even change values.

Why can I not completely erase some columns?

2

On 11.01.2008 15:32, Nikos Alexandris wrote:

Is it a limitation of SQLite or OOo DB that I cannot "drop columns" from
within OOo?

I connect witouth any problem to my sqlite.db, can retrieve the database
and even change values.

Why can I not completely erase some columns?

SQLite doesn't support drop column, by design. Here is how GRASS goes around the problem:
http://grass.gdf-hannover.de/wiki/Sqlite_Drop_Column

--Wolf

--

<:3 )---- Wolf Bergenheim ----( 8:>

3

YYYYYYYYYOuuuuuuwhooooooooooooooo!!!!!!!!

sqlitebrowser is superbe!!!!!!!

Thanks for the tip!

So easy and fast... !

On Fri, 2008-01-11 at 15:44 +0200, Wolf Bergenheim wrote:

On 11.01.2008 15:32, Nikos Alexandris wrote:
> Is it a limitation of SQLite or OOo DB that I cannot "drop columns" from
> within OOo?
>
> I connect witouth any problem to my sqlite.db, can retrieve the database
> and even change values.
>
> Why can I not completely erase some columns?
>

SQLite doesn't support drop column, by design. Here is how GRASS goes
around the problem:
http://grass.gdf-hannover.de/wiki/Sqlite_Drop_Column

--Wolf

--
Nikos Alexandris
.
Department of Remote Sensing & Landscape Information Systems
Faculty of Forestry & Environmental Sciences, Albert-Ludwigs-University Freiburg
.
Tel. +49 (0) 761 203 3697 / Fax. +49 (0) 761 203 3701 / Skype: Nikos.Alexandris
.
Address: Tennenbacher str. 4, D-79106 Freiburg i. Br., Germany