Couple of newbie questions

[tcrabb]

Couple of quick questions :

1. I have a table within a form, each row of the table hold a single record. I would like to be able to click on a row which would bring up that paricular record with each field appearing in text boxes etc. much like Sage or ACT! behaves. I would prefer if this occurs within the same windows frame rather than initiating a mini pop-up.

How easy would this be to do?

I have some Java knowledge and could pick up some Python if I needed to but a non-coding solution would be best.

2. One field is a boolean value which is displayed using a check box. I have worked out how to turn tri-state off but this does not affect the way the check box appears in table view - it still has a tri state with the green colouring. Can I change this behaviour so that it is just dual state within the table view ie. checked or unchecked.

This next question should really be posted elsewhere but...

3. We are setting the database up with just the default HSQL engine.

As far as I can tell the database file can be shared but only one user will have write access any subsequent users just see a snap shot of the data. Any changes that are made by the first user (who has write access) will only be seen when he has closed the db file and a subsequent user reopens the file following it being closed by the first user . So the data modifications or additions cannot be viewed in real-time by secondary users (who have read only access) as it changes.

Are there any known-issues with this set up? It seems to suit our needs OK.

[Villeroy]

1. Form <-> Subform Example database related to thread Where is the Enforce Referential Integrity Option?. Open a form in edit mode (right-click) and call the "Forms Navigator" from toolbar "Form Design".

2. Booleans null, true, flase

3. You can have privileges for users and groups with multi-user access when you use any other database server, including hsqldb as stand-alone server application.

[tcrabb]

Thanks very much for the reply.

1. I have downloaded this example database but the table displayed by the form does not seem to have the behaviour that I was looking for.

I want to allow the user to be able to click (or double click) on a row then this would bring up a form containing the data from that record. Ideally this would replace the existing form somehow until the record is closed then the table view is restored.

Does anyone know if this is possible to do in Base? If so then by what technique?

I am from a Java programming background - in Java this would be a doddle but whether Base is extensible enough for this I do not know.



2. Villeroy, your advice worked perfectly on my second question using...

UPDATE "Table" SET "bool_field"=False WHERE "bool_field" Is Null

for changing all entries in the boolean field. So thanks!

[Villeroy]

Base has no form designer so it lacks interfaces that treat forms like modal dialogs. All forms are more or less sophisticated Writer documents. You can implement dialogs through OOo's own awt-API and you may be able to hack some activation listeners to make Writer documents behave like dialogs. AFAIK, there is no way to load a form from another form without programming. Beeing fluent in some programming language is one thing, talking to the API of this office suite is quite challenging. For simplicity I would suggest: If you want to use another form, switch to the database window and double-click.

This is a Report Runner Add-On. May be someone writes something similar for forms. I certainly won't.

[tcrabb]

Thanks again for the response.

That has clarified what is and what is not possible.