OOo20 database

older
Re: [suse-linux-uk-schools] OOo20...

Ian Lynch

25 Feb 2005 25 Feb '05

09:03

Jacket Potato is a sample ready made database for the OOo 2.0 embedded database. It means you have a ready prepared data source with which to start teaching/learning. http://nothickmanuals.info/doku.php?id=jacketpotato -- Ian Lynch ZMS Ltd

Show replies by date

Roger Beaumont

27 Feb 27 Feb

00:31

New subject: [suse-linux-uk-schools] OOo20 database

On Friday 25 February 2005 09:06, Ian Lynch wrote:

...

Jacket Potato is a sample ready made database for the OOo 2.0 embedded database. It means you have a ready prepared data source with which to start teaching/learning.

I have a tab-separated text file containing the 217 entries for one complete year in the Heptonstall (near Hebden Bridge, Yorkshire) parish register of baptisms. (Sorry, I don't know which year, but I'd guess sometime in the 19th C). Fields are: month (numeric & as text); infant's name; father's forename, surname and occupation; and the township within Heptonstall parish. Being real individuals, but dead (thus outside the statutary scope of the DPA), I've found it has been more interesting for students than some other sample data sets, not only because it contains odities like Tho Pickles, Inkeeper (who had no less than 7 offspring baptised at the same time), a number of fathers with no occupation (unemployment isn't new!), entries such as that for Salley (whose 'father' is recorded as "Jane Jackson, Spinster"), not to mention several archaic occupations, such as Webster and Cordwainer. All those can provide associated research projects which bring the data to life - and thus make the database operations themselves interesting. Finally, its size makes it manageable for data entry (I used to split a class into 12 and give each team 1 month's data to enter, then concatenate them myself, but, of course, in tab-separated form, you can simply import it). If anyone wants a copy - or would like to post it on the web as a public resource - please apply off-list, with "Heptonstall Baptisms" in the subject line (so I can reconise the msg isn't spam). Hope that's useful, Roger

Matt Johnson

01:28

New subject: [suse-linux-uk-schools] OOo20 database

Hi all, I've just grabbed the preview of OO.o2 tonight, and I'm very impressed with what I've seen. Nice improvements all round so far. The "Base" app is the one. Real potential. Forms: I haven't got it using a TableB as a lookup for the list values in a combobox on FormA, where FormA edits and adds to TableA (you know - that wizard you run on Access to get combobox values from somewhere else (a table) and bung an id rather than the list value into the main table). The Base combobox wizard itself doesn't want to list *any* tables as sources to choose from. The wizard list is empty. If anyone figures it out... let me know. It might be that it's not written yet. Anyway, if you haven't seen this preview release yet it's well worth half an hour. Exciting stuff. Oh, and the icons are sweet as a nut. *Much* improvement there too. Will look great on our school desktops... -- Matt Send instant messages to your online friends http://uk.messenger.yahoo.com

Thomas Adam

28 Feb 28 Feb

00:00

New subject: [suse-linux-uk-schools] OOo20 database

--- Matt Johnson wrote:

...

Hi all,

Cor, are you stalking me? This is the second list I've seen you on. :)

...

I've just grabbed the preview of OO.o2 tonight, and I'm very impressed with what I've seen.

It's not bad, is it? Granted, I rarely use it, but for someone converting from Windows, OOo does tend to boost Linux's applicability.

...

Forms: I haven't got it using a TableB as a lookup for the list values in a combobox on FormA, where FormA edits and adds to TableA (you know - that wizard you run on Access to get combobox values from somewhere else (a table) and bung an id rather than the list value into the main table).

A classic MS-Access ideal - and one that teaches so many how not to design forms and database backends. I don't want to get into that argument, but as a toy database, this'll do just fine. :P

...

The Base combobox wizard itself doesn't want to list *any* tables as sources to choose from. The wizard list is empty.

I think you'll find this is deliberate. -- Thomas Adam ===== "The Linux Weekend Mechanic" -- http://linuxgazette.net "TAG Editor" -- http://linuxgazette.net "<shrug> We'll just save up your sins, Thomas, and punish you for all of them at once when you get better. The experience will probably kill you. :)" -- Benjamin A. Okopnik (Linux Gazette Technical Editor) Send instant messages to your online friends http://uk.messenger.yahoo.com

Matt Johnson

17:57

New subject: [suse-linux-uk-schools] OOo20 database

--- Thomas Adam wrote:

...

--- Matt Johnson wrote:

...
Hi all,

Cor, are you stalking me? This is the second list I've seen you on. :)

Hmmmm. Yes, your celebrity is widely talked of. Come now... I know it is your desire to be a primary teacher that has lead to *you* following *me*. ;)

...

...
The Base combobox wizard itself doesn't want to list *any* tables as sources to choose from. The wizard list is empty.

I think you'll find this is deliberate.

Don't think so. OO2 presents you with a wizard that has no options to continue... ie. Choose one of the tables below: (this section is intentionally left blank!) Nada. Nothing. Zilch. Now I'm well prepared to believe that I've hosed up an earlier decision in the wizard or form creation, but I don't think the wizard deliberately poses a question for the user not to be able to answer. -- Matt Send instant messages to your online friends http://uk.messenger.yahoo.com

7006

Age (days ago)

7009

Last active (days ago)

List overview

Download

4 comments

4 participants

participants (4)

Ian Lynch
Matt Johnson
Roger Beaumont
Thomas Adam

OOo20 database

Ian Lynch

Roger Beaumont

Matt Johnson

Thomas Adam

Matt Johnson

tags

participants (4)