Simple Question

Results 1 to 3 of 3

Thread: Simple Question

  1. #1
    Sharon B. Guest

    Default Simple Question

    Is there any way to delete only the CONTENTS of a SINGLE (Access) database FIELD in SQL/ASP as apposed to the entire row?<BR><BR>For example: When I type…<BR>&#060;%<BR>MySQL = "DELETE FieldName FROM MyTable WHERE CertainField = &#039 MyCondition &#039”<BR>%&#062;<BR>…will delete the entire row, and all I want is - to erase the contents of that particular field (“FieldName“ ).<BR>

  2. #2
    Mr Swifty Guest

    Default RE: Simple Question

    You could use the UPDATE keword instead of DELETE, eg.<BR><BR>UPDATE Table SET Field = Null WHERE Field = Whatever

  3. #3
    Sahron B. Guest

    Default RE: Simple Question

    yeah... but when I do that it inserts a "0" into the field as opposed to Null (or blank field)<BR><BR>see 2 postings above (a tougher question)<BR><BR>Sharon

Posting Permissions

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