>this is the data i need to update Time-Out Field when i try with UPDATE SQL command it is updating both row.is there way to update only one row..?
>
>Date Time-in Time-out
>01/01/2008 9:00 Am 2:00 pm
>01/01/2008 4:00 pm 10:00pm
It may help if your table has a primary key, apart from any data the user enters.
Whether the date is the primary key or not, you can avoid duplicate data by declaring an index on date (or on a combination of date and time-in; whatever you want to be the data that doesn't gets duplicates). Declare the index either as primary, or as candidate. In this case, your users won't be able to introduce duplicate data in the first place.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)