Frank Schönheit - Sun Microsystems Germany wrote:
Hi Mechtilde,
1 Searching through the various helps, it would appear that you can pull a
csv file into a base 'view' but as yet can't do anything other than view the
data.
because csv files don't normally use primary keys. If you convert csv
file to the internal HSQl or another DB and give them a primary key then
you can do more.
Sigh. That's a pertinacious urban legend.
The requirement for updatability is
1. have privileges to update
2. have a driver which supports updates
3a. have a primary key
OR
3b. have a driver which supports so-called bookmarks (a way to uniqueley
identify rows)
The CSV driver fulfills 1. as soon as you have write access to the file,
plus 3b., but *not* 2. Updates are simply not implemented for CSV files,
no matter whether there would be a primary key or not.
There is another option. If you make the effort ( not that much ) to
define a TEXT TABLE within a Base embedded database ( HSQLDB ) then you
will have an updatable CSV file connection. ( Actually for it to be
updatable that way you still must be able to designate some column as
the PK ) For information about this I would direct you to the HSQL
users manual, found at their web site http://hsqldb.org a sceondary help
might be this poting from the OOoForum writer board
http://www.oooforum.org/forum/viewtopic.phtml?t=29915 in it there is a
detailed example of setting up and using an HSQL TEXT TABLE under OO.
Drew
