I have a simple, one table, database to hold an internal telephonedirectory. All is working well, except for the update. If Iedit a record, and for example, enter a value in a field that is blank,and then update, nothing happens! However, if i alter data thatwas already in that field and update, the changes take effect!!
Any help with this would be gratefully received,
Thanks in advance,
Vern.
I have been able to do this in Visual Web Developer 2005 Express. I just make a gridview or detailview and when going through the wizard for configuring the source for my SELECT I check *, then I click "Advanced" and select the Generate UPDATE, INSERT, DELETE ( i dont remember exactly what the name of it is, but its the only radio button you can select under advanced as long as the SELECT is set as *. After that just click next through the wizard, test your query if you want and click finish. Run your site and it should work.
I hope this helps, again I did this all with Visual Web Developer 2005 Express and didn't need to write any code, I am not sure how you are approaching this but if you want to use this was very easy, probably took literally 45 seconds to get working.
Good luck,
Brian
Thanks for the reply Brian.
However, that exactlyhow I set it up. The strange thing is that I have now set thedefault value for a field to '-'. This means there is alwayssomething ing the field to start with. The field will then updatewhen the - is deleted and new data entered. What still is notworking, is that if you delete the data and then update, leaving thefield empty, you cannot then edit that field in the same way!