Frank Häusler wrote:
Brian Barker schrieb:
At 19:43 15/04/2008 +0200, Frank Häusler wrote:
I created a simple database from an excel-sheet.
Now I created a form with the wizard ==> ok.
When I double-click the form to use it for data entry it does not work.
The opened Writer-Document shows in the title-bar the name I gave to
the form and the additional text "(schreibgeschützt)" english:
"(read only)".
I don't think this is a problem. The "read-only" attribute applies,
I think, to the *format* of the form, not its contents. It prevents
the user changing the appearance or layout of the form, but it
doesn't prevent the insertion of data and its saving to tables in the
database.
I don't suppose anyone can help you if all you say is that entering
data "does not work". One possibility, of course, is that the
combination of fields that you have included in the form prevents you
from adding essential data. If, for example, you have a field that
is marked as "Entry required" but it does not appear in the form,
then you will not be able to enter new records. This applies in
particular to the primary key; you can avoid the problem in that case
by setting this to AutoValue.
I trust this helps.
Brian Barker
Thank you for your advice. Because I created the form using the
form-wizard, I made no special definitions for the fields by myself.
I used to define the type of form regarding the possibility to input
data the second option on STEP 6 ("The form shows existing data") with
no suboption of this item checked.
Entering Data does not work, because nothing you type in appears in
the field. You can only set the cursor into the different datafields -
thats it. I can walk through all the records, but the button to add a
new record is diabled. So I can only watch the records.
Anothe point is, that searching does not work too. Even within a
record you can not find some text.
Therefore I'm only wondering what sense the form-wizard has, when it
produces only useless forms.
Best regards Frank Häusler
Hi Frank,
Sorry for such a long delay here, just didn't notice your response I guess.
Most likely you are way past this - but the most likely reason for your
problem is ( was ) that the table did not have a primary key. Base
requires that a table have a primary key if you want to edit data in UI
forms, period. ( You can update tables without primary key fields via
scripts and direct SQL commands in Base however.
Anyway - gain, sorry for the delay and I hope you finally got this
worked out.
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
