Joined: Jul 05, 2005 Posts: 685 Location: North West England
Posted: Wed Oct 21, 2009 3:01 pm Post subject:
I wonder if I can ask for a bit more help. I'm now trying to create a set up where I can view the part of the contents of the Books Catalogue and the Saward Classification tables together, and which will update when I add new items to the Books Catalogue table. I have tried queries, but AFAICT they are stuck at the point when you run them and they don't update when new data is added. I have tried table views, but they also seem to have the same problem
Any ideas? _________________ MacBook Pro
13-inch, Mid 2012
Processor 2.5 GHz Intel Core i5
Memory 4 GB 1600 MHz DDR3
Graphics Intel HD Graphics 4000 512 MB
OS X 10.9.3 (13D65)
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Wed Oct 21, 2009 3:19 pm Post subject:
Queries should update when you add or change data. Why don't you send me your odb file as it stands now.
It may be a while before I can get to it. One of my children has been home sick with both strep and influenza, and my own temperature is climbing tonight, so I may not be good for anything for a few days.
Send it anyway, as there may be a point in my recovery when I need something quiet to keep me occupied.
Joined: Jul 05, 2005 Posts: 685 Location: North West England
Posted: Thu Oct 22, 2009 2:36 am Post subject:
Very sorry you're not well - and it's even more worrying with children too. I hope it passes soon.
In the meantime in the clear light of day, I've taken another look and discovered the source of my problem. I had already discovered yesterday that I might need to set update and delete cascades in the relationships between the main Books Catalogue table and the Saward Classification table, so I've done that (I'm still not 100% sure it was necessary). But the main problem was a data error on one record which meant that that record was being excluded from all my Views, Queries etc., and of course that was the record I was checking to see if things were working properly. If I had checked the other recently added records I would have found they were all right, and got to the problem on this one more quickly.
I have now produced a table view which combines Books Catalogue fields with Saward Classification fields, and sorts by Genre, Class# author's names, and title. I have then created a query based on that view which finds only the Theology 'Genre' books which are not pamphlets. This now gives me a shelf listing for my work related library.
I am very happy to send it through to you if you want to see it (although you've obviously got plenty on your plate at the moment), but at the moment I don't think I am in need of help (or at least not with NeoOffice anyway!). _________________ MacBook Pro
13-inch, Mid 2012
Processor 2.5 GHz Intel Core i5
Memory 4 GB 1600 MHz DDR3
Graphics Intel HD Graphics 4000 512 MB
OS X 10.9.3 (13D65)
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Thu Oct 22, 2009 5:30 am Post subject:
I'm glad you got it working.
Thanks for the good wishes. Fortunately this morning I'm only feeling moderately ill. I still have vivid memories of the last time I got influenza, 20 years ago while studying in France--one of the rare years when I did not get a flu shot. I was one sick puppy! Last night I was steeling myself for a repeat of that experience, but in the light of morning it looks hopeful that it will not be that bad this time around.
My child is much improved, which is indeed a relief.
All times are GMT - 7 Hours Goto page Previous1, 2, 3
Page 3 of 3
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum