Hi Barbara, > Yes, that was the specific question (let's call it Issue 1). In this > case, it would be complicated by the fact that Base did not define the > PK it generated for the original .dbf import as auto-increment.
This would be an RFE (request for enhancement) in IZ, to have an option to create the PK as auto-increment, if possible. > So as > things stand now, the first db table would probably have to be copied to > create a second that was defined as really intended, before Base would > know the pattern to use. Or you could change the type of the auto-generated PK to be an auto-inc value. > Also, in preparing this material to go to these people it would be nice > if I could copy a rectangular block from an existing database table or > query (Issue 5). okay, copying a sub-range of a table/query to somewhere else is something I'd easily agree is useful. > As is, I often have to create a query with the specific > subset I need. Once I have a query that's as close as I can get, I copy > all its data, paste-special into an empty portion of the destination > document (haven't tried this with Calc, just Writer), delete/reformat > columns as required, copy, and paste into my destination table. Since > Base seems to "like" Calc better, the transfers might be smoother there I see. So you need this because Base itself lacks certain editing capabilities ... > OK, Issue 6. When copies fail, they don't provide any info about where > they hit the snag. Ah yes, this one ... I agree this is (and has always been) annoying. I'd say you create a small sample .ods, a small sample .odb (with data where copying will fail at some record inbetween), a short description what to do - and put this into IssueZilla :) Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
