That pk limitation is odd. PKs are very useful, but there ARE occasional times where a PK is not needed. But now that I think about it, I'd have to work hard to find a reasonable situation where this may be the case...
Then again, people who really understand the uses of primary/foreign keys probably aren't using Base natively like that. Glad to hear you got it working though. Shawn TekBudda wrote: > It did it on both... but the link the neil sent led me to the right > path....as long as there is a primary key in the db you are ok....you can > set the pkey to not require input and hide in the table.... > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of sgrover > Sent: August 16, 2007 11:17 PM > To: CLUG General > Subject: Re: [clug-talk] Help: OpenOffice Base > > Odd. > > I just installed Base (wasn't there), and told it to create a new > database (native base file, stored under my home directory). Then used > design view to create a table. Then opened the table and added records. > Didn't run into any issues... > > Maybe try removing/reinstalling Base? Perhaps you are missing a > library? (is this a windows or linux box?) > > Shawn > > TekBudda wrote: >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf >> Of sgrover >> Sent: August 16, 2007 2:57 PM >> To: CLUG General >> Subject: Re: [clug-talk] Help: OpenOffice Base >> >> First, check the file permissions. Can you read the file? (obviously >> you can to some degree....) >> * First thing I did...no dice! I can see the headers for the table but >> cannot add records. Tried all of the different options available when >> creating it....still no joy! >> >> Second, check the database properties in Base - is there a read only >> setting there? (can't say fer sure cuz I typically use >> MySQL/PostgreSQL/MSSQL for my database needs - not native BASE.) >> * I wanted to try and emulate a "typical" puter user who is used to the >> "make everything simple for me" MS world where they may have just opened >> Access and poof! I know OOoBase can connect to other databases, but for > the >> average user.. they may not know this. >> >> If you were connecting to an external database I would also suggest >> checking the permissions for the account you are using to connect. It >> could have Select permissions only. To add rows, you'd need select, >> insert/update, delete usually... >> * I wasn't trying to connect to an external db on this. I did create a >> spreadsheet with some information in it, but at this point I can't even > see >> where I would be able to import from there. Hmmm one step at a time I > guess >> Try opening base as Root and see if that clears up the problem >> (stretching here again...) >> * Nope >> >> Another thought - try moving the file to the local box. I know Writer >> doesn't like to open files it doesn't think are local... >> * Trie it.. no joy! Even tried creating a brand new db from scratch on > the >> desktop...same results. >> >> >> _______________________________________________ >> clug-talk mailing list >> [email protected] >> http://clug.ca/mailman/listinfo/clug-talk_clug.ca >> Mailing List Guidelines (http://clug.ca/ml_guidelines.php) >> **Please remove these lines when replying > > _______________________________________________ > clug-talk mailing list > [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying > > > _______________________________________________ > clug-talk mailing list > [email protected] > http://clug.ca/mailman/listinfo/clug-talk_clug.ca > Mailing List Guidelines (http://clug.ca/ml_guidelines.php) > **Please remove these lines when replying _______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
