I'm referring a question here that I asked on the users list -- any
suggestions? (PS - I've sent the subscription message but haven't gotten
the confirmation at this point.)
NoOp wrote:
On 07/27/2007 07:17 PM, Barbara Duprey wrote:
I'm having a serious, and very hard to notice, problem with the
reliability of updates to a database. I have a .dbf file linked to an
.odb file, and when updating from queries in the database the changes
are (occasionally) applied to the wrong record. I haven't been able to
isolate what causes the problem, although I suspect it has to do with
there being no way to specify a key field. Because the problems are
unpredictable and can easily be missed, I have to either give up on Base
entirely, or find a reliable way to do the updates. I really want the
ability to query, this is a large and active database that needs to be
looked at in different ways. There is only one table involved, though.
Is there some way I can capture the table into the .odb file directly,
and then add an auto key? Or does anybody have any other suggestions?
This issue is a real killer for me, and I'm under a lot of time
pressure (have to get the current crop of updates done by tomorrow
morning, and it's after 9 pm here now).
Barbara, not sure exactly what the problem is or what you need to do,
but two suggestions:
1. Try your question on the database mailing list as those folks pretty
much live & breath Base:
http://dba.openoffice.org/
http://dba.openoffice.org/servlets/ProjectMailingListList
Note: [EMAIL PROTECTED]
2. If you can see the link in tables, right click on the table and click
open. You can then manually edit if necessary.
Hopefully that will get you through until you have time to help
troubleshoot the problem.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I'll try the database mailing list, thanks for the pointer.
Not sure what you mean on the second point. I can look at and edit the
.dbf either through the Table or the Query from the database, though I
normally do it from the query; the underlying file is updated either way
(gets current timetag in the Windows Explorer details). I suspect that
the problem has something to do with records not really being updated,
but held in working storage, until I completely close the session -- or
maybe shut down the computer. (Another mystery has been that even when I
have left no applications open, OpenOffice.org insists on "recovering"
the database file (unnamed in the list) before I can open anything, even
a Writer doc.) This last time, I was careful to save from the query
after each individual update, and save from the main Base dialog at
various checkpoints, but the problem still cropped up. Sigh.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]