Hi Bill, > I think Base took a couple steps backward in the 2.0 release. I've been > going nuts trying to figure out how to update or add records and had no > idea that not having a primary key in my db was the problem. This thread > was my first clue, although the situation may have been documented > elsewhere, as indicated above. I sure couldn't find anything in the help > files to this effect. > > Doesn't this make porting a Calc or Excel file to Base a lost cause, > except for viewing purposes? If you can't change the database how can > you add a primary key? > > Some of us non-purists see nothing wrong with having duplicate records > in a flat-file database.
Flat-file and Calc are always readonly, but this has nothing to do with primary keys (and, btw., _nothing_ changed in this respect between 1.x and 2.0). In my original post in this thread, I explained that PKs are only *one* way to ensure updatability, the other way needs to be supported by the respective backend. Even then, there are more reasons why a certain backend type may not be updatable, most obvious: It's simply not implemented - and exactly this is the case for the Calc and the flat-file driver. 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]
