How to edit records in query results

Is this something related to this?

http://www.oooforum.org/forum/viewtopic.phtml?t=71675

Hi :)

I think the question is are you trying to edit the query itself or edit the data contained in the query? Also is it a relational database, with many tables linked together to produce an output in a query or is it a normal (default) flat single table with the query simply providing a useful lookup based on selected criteria?

I am not sure which of those thing Voobase's answer addresses
"They should do by right clicking on them and choosing edit. Check you have the HSQL database by looking at the bottom of your dB window and that you are not accessing your db file twice. HSQL only allows one user to have write access at once. For multiple users you need to link Base to a different backend like MySQL. Also do you have an auto incrementing primary key? "
as it has been many years since i last used MS Access which is the most similar thing i have used to Base. Please try right-click on the bit you want to edit and let us know if that has the desired effect.

Regards from
Tom :)

However if you are trying to develop a personal finance (or even business finance) package then have you looked at "gnucash"?

I would use Synaptic Package Manager
https://help.ubuntu.com/community/SynapticHowto
to look up and possibly install financial management package, bookkeeping packages and stuff like that to see if there's something already done that you could use as a good starting point.

Alternatively for the tick-box approach that you mentioned you might have to include a column in the table that has the list of cheques in. I imagine that Base must be able to have a standard "Yes/no", "On/Off" binary style field that wouldn't add tooo much extra to the tables 'weight'

Good luck and regards from
Tom :)

You can create a Query (using Create Query in design view is quite easy) that will select only data you need to see for unbalanced entries. Then if you double click the Query to open it, you will find that you can edit the data in it, and when you close it, the changes are written back to the underlying base table.

You could also create a Form that you can modify the data in.

There is some documentation about Base, but it is not a comprehensive as for other parts of OOo. See:

http://documentation.openoffice.org/

or more specifically:

http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Getting_Started/Getting_Started_with_Base

However, I agree with Tom that you should look at ready made applications, like gnucash, before you re-invent the wheel!

Tony

Is there something I need to do when creating the query to allow me to edit the records that it finds? Tony makes it sound like it should already do it but it does not work. In this particular case I am querying one table to pull out only records that are not marked as finished. I want to be able to check off some of them right in the results and have the base table be updated. As far as gnucash, I just used the checkbook as an example of the specific function I need to do since it was easier to explain. I know how to edit the query that is not the issue.

I will admit that I tested this in Windows XP, but there is usually no difference.

I also assume that your data source is the default HSQLDB used by Base and not MySQL or a spreadsheet, for instance. I was also using OOo ver 3.

The test database I used was an address list for Xmas cards. My query was a simple single table select where 'type' = 'family' and I was able to change the 'label' field from 'Y' to 'N', both by opening the query, or by creating a simple form.

Does your test case differ significantly from this?

I have just retested in Ubuntu 9.04 (on my trusty EEEPC). Everything the same as I described for XP. Does work just the same.

Have you checked the file permissions on the odb file? I assume it has to be read/write for you.

Tony

Thanks Tony Pursell, that solved my question.