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.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
