Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2005
    Posts
    55

    Unanswered: update char field...

    ok, so we have a field in one of our db's, a do_not_synch field. this field has a datatype of char...

    the following sql statement does not update the field..

    Code:
    update contacts
    set do_not_synch = 'Y'
    where id=1
    and if i open up the table in sql server management studio, and cannot type in and save the value Y...yes i can update other fields in this row...so its not a permissions issue?

    is there anything special i should have to do?

    Cheers,
    Justin

  2. #2
    Join Date
    Aug 2005
    Posts
    55
    sorry guys,

    turns out there was a trigger on the table on the field, that would do other stuff, then change back to empty...

    resolved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •