Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
12  2070 
birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
Francesco in the previous post mentioned a primary key on the name *AND* the
date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl... Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
Francesco in the previous post mentioned a primary key on the name *AND* the
date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl... Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
Francesco in the previous post mentioned a primary key on the name *AND* the
date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl... Sorry that won't work.
Because every member should be able to confirm that they are present on a
specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote: Howe can i prevent a double entry in a database.
Users can input their data into table.
But how to prevent a double entry.
Users can enter name and date
So users can enter their names only on one date.
Please help.
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
because a primary key can be made up of more than one field..
"David L" <dl@nospam.com> wrote in message
news:v5******************@news-server.bigpond.net.au... Francesco in the previous post mentioned a primary key on the name *AND*
the date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl... Sorry that won't work.
Because every member should be able to confirm that they are present on
a specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote:
> Howe can i prevent a double entry in a database.
> Users can input their data into table.
> But how to prevent a double entry.
>
> Users can enter name and date
> So users can enter their names only on one date.
>
> Please help.
>
>
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
because a primary key can be made up of more than one field..
"David L" <dl@nospam.com> wrote in message
news:v5******************@news-server.bigpond.net.au... Francesco in the previous post mentioned a primary key on the name *AND*
the date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl... Sorry that won't work.
Because every member should be able to confirm that they are present on
a specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote:
> Howe can i prevent a double entry in a database.
> Users can input their data into table.
> But how to prevent a double entry.
>
> Users can enter name and date
> So users can enter their names only on one date.
>
> Please help.
>
>
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
because a primary key can be made up of more than one field..
"David L" <dl@nospam.com> wrote in message
news:v5******************@news-server.bigpond.net.au... Francesco in the previous post mentioned a primary key on the name *AND*
the date, so it should work...
"birdy" <bi***@quicknet.nl> wrote in message
news:ee***************************@news.multikabel .nl... Sorry that won't work.
Because every member should be able to confirm that they are present on
a specific date.
Also other members must be able to use the same date.
So the combination member and date must be unique.
"Francesco" <pl***********************@thanks.net> schreef in bericht
news:40**********@news.tiscalinet.ch... birdy wrote:
> Howe can i prevent a double entry in a database.
> Users can input their data into table.
> But how to prevent a double entry.
>
> Users can enter name and date
> So users can enter their names only on one date.
>
> Please help.
>
>
Hi,
you can make define the name and date field as the primary key for the
table. the primary key is unique and if you try to add another record
with the same value, mysql will give you an error.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Vincent Texier |
last post by:
Hello,
I want to send 3 chars in hexa code to the serial port.
So I type in a tkinter entry : "\x20\x01\x21"
The string is set in a StringVar().
When I read the stringVar, I get :...
|
by: Venkat |
last post by:
Hi All,
I need to copy strings from a single dimensional array to a double
dimensional array.
Here is my program.
#include <stdio.h>
#include <stdlib.h>
|
by: jhwagner |
last post by:
I need to use double data entry with an MS Access database. I have
read many arguments and reasons against this on this group but I have
to do this. I have seen various tips on how this can be...
|
by: Asha |
last post by:
hello,
every time i refresh my page i get a double entry? how can i solve this issue?
|
by: akang2005 |
last post by:
When I write 'double' data to the file, it seems working fine, but when
I read it later, it returns a eof when it encounters a particular
number even the file is not at the end yet. However, while...
|
by: hippomedon |
last post by:
Hello everyone,
I'm looking for some advice on whether I should break the
normalization rule. Normally, I would not consider it, but this seems
to be a special case.
I have created an...
|
by: imrosie |
last post by:
Please help with this one,,,,,I've been trying everything in my arsenal to fix this one. I'm stumped....
I"ve got a unbound combo box (customername) that has two events (on click); AfterUpdate and...
|
by: Wayne |
last post by:
I'm building a bookings database for trucks that among other things
captures the TruckName, LoadDate, LoadTime, UnloadDate and UnloadTime.
Is there a simple way to prevent double bookings for any...
|
by: David Wright |
last post by:
Hello All
I am using Microsoft Access 2003. I have an input form (Single Form) into which the clerk records appliance details. Some appliance details will never change, for instance the 'Make...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
