Skip to main content
L
lands1ide
Inspiring
September 22, 2006
Question

Help Please

  • September 22, 2006
  • 1 reply
  • 317 views
I want to update a record, But I do not want it to overwrite fields that already have data in that record.
This topic has been closed for replies.

1 reply

A
Anonymous
October 1, 2006
Hi,

If you want to update it, but not delete it, then you really want to insert some new data. Not sure exactly what you need the old data for, but....

You can always add a unique identifier to the table or a datetime value to each new record of data you ad to the database. This can be sorted in your sql statement.

Hope this helps.
L
lands1ideAuthor
Inspiring
October 4, 2006
Im sorry let me explain this a little better. The page is to request leave. I am using an update record method. origionaly all boxes will be blank when they request leave. when they hit submit it inputs a r into the database. We go into the database and change the r's to a's or d's based on if it is approved. If they want to request additional leave. they pull up the same page. I wanted it to prevent employees from checking or unchecking a box that they have already been approved or denied for. I am trying to keep each employee to only one record since the insert record make duplicates and is hard to sort through. I hope that helps. Thanks again for your help. I am very gratful. .
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices