Changing a column

Results 1 to 6 of 6

Thread: Changing a column

  1. #1
    Changing a column Guest

    Default Changing a column

    Hi i need help :(<BR><BR>i have a column and need to change every value in the column, to a zero, can somone help me with the SQL to do this.<BR><BR>thanks for your help. <BR>Tony.<BR><BR>NB, the table name is &#039;TODO&#039; and the column is called &#039;postpone&#039;

  2. #2
    Join Date
    Dec 1969

    Default You'll be amazed... how easy this one is:<BR><BR>&#060;%<BR>...<BR>SQL = "UPDATE TODO Set postpone = 0"<BR>yourConnectionObject.Execute( SQL )<BR>...<BR>%&#062;<BR><BR>That&#039;s it. Period.<BR><BR><BR>

  3. #3
    Tony Guest

    Default RE: You'll be amazed...

    Thank you VERY much, i must have tried a hundred alternatives, should have asked here first.<BR>:-)<BR>Tony.

  4. #4
    Join Date
    Dec 1969

    Default Just out of curiosity..

    ..what alternatives did u try, dont tell me u were updating each record at a time :)

  5. #5
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Even THAT is an alternative...

    ...and it would still work. More time but it would work ....what did he try, let me tell you...IMO..nothing.

  6. #6
    Tony Guest

    Default RE: Even THAT is an alternative...

    I lost my book, (im new to this) and so i was trying to do it using an INSERT statement.<BR><BR>stupid i know but i didn&#039;t know there was an update.<BR><BR>Tony.

Posting Permissions

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