Re: [SQL] Multiple Index's

2000-09-21 Thread Mitch Vincent
Hello all, How would I prevent a user from submitting information to a table once they have already done so for that day. The best you could probably do is to go back and delete undesired recoords at the end of the day because if it is as you said, they've already put the information into

Re: [SQL] Multiple Index's

2000-09-21 Thread Stephan Szabo
On Thu, 21 Sep 2000, Brian C. Doyle wrote: Hello all, How would I prevent a user from submitting information to a table once they have already done so for that day. I would need them to be able information on future dates as well as have information in the table from past dates from

Re: [SQL] Multiple Index's

2000-09-21 Thread Mark Volpe
CREATE TABLE user_info(user_id name, entry_date date, info text); CREATE UNIQUE INDEX user_info_key ON user_info(user_id, entry_date); "Brian C. Doyle" wrote: Hello all, How would I prevent a user from submitting information to a table once they have already done so for that day. I would

Re: [SQL] Multiple Index's

2000-09-21 Thread Brian C. Doyle
See if this help the table has userid | date | helped_customers An employ will enter in their userid, the date and how many customer they helped that day. What I want to do is prevent the employees from enter the data more than once a day At 10:28 AM 9/21/00 -0700, Mitch Vincent wrote: