Document Foundation Mail Archive › LibreOffice › Users

Data Entry in a Form

Classic

List

Threaded

4 messages Options

Herman Leggon

Data Entry in a Form

I've design and created a simple database(mailing list). But I having trouble adding items to the database. What am I missing?
--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Regina Henschel

Re: Data Entry in a Form

Hi Herman,

Herman Leggon schrieb:
> I've design and created a simple database(mailing list). But I having
> trouble adding items to the database. What am I missing?

What kind of database do you use? You find this information on the left
side of the status bar. If it is a embedded HSQL database, the most
likeley reason is, that you have missed to define a premary key.

Kind regards
Regina

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Herman Leggon

Re: Data Entry in a Form

Regina

Thanks!!!!!!!!!!!!!!!!
I did not include a key because there was no need to identify the entry as unique. There are only 20 records…

Herman
On May 13, 2012, at 5:45 PM, Regina Henschel wrote:

> Hi Herman,
>
> Herman Leggon schrieb:
>> I've design and created a simple database(mailing list). But I having
>> trouble adding items to the database. What am I missing?
>
> What kind of database do you use? You find this information on the left side of the status bar. If it is a embedded HSQL database, the most likeley reason is, that you have missed to define a premary key.
>
> Kind regards
> Regina
>
>
>
> --
> For unsubscribe instructions e-mail to: [hidden email]
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Jay Lozier

Re: Data Entry in a Form

On 05/13/2012 06:03 PM, Herman Leggon wrote:
> Regina
>
> Thanks!!!!!!!!!!!!!!!!
> I did not include a key because there was no need to identify the entry as unique. There are only 20 records…
>
> Herman
Herman,

I find it good practice to always define a primary key. The simplest is
to assign a key using integers.

> On May 13, 2012, at 5:45 PM, Regina Henschel wrote:
>
>> Hi Herman,
>>
>> Herman Leggon schrieb:
>>> I've design and created a simple database(mailing list). But I having
>>> trouble adding items to the database. What am I missing?
>> What kind of database do you use? You find this information on the left side of the status bar. If it is a embedded HSQL database, the most likeley reason is, that you have missed to define a premary key.
>>
>> Kind regards
>> Regina
>>
>>
>>
>> --
>> For unsubscribe instructions e-mail to: [hidden email]
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be deleted
>

--
Jay Lozier
[hidden email]

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted