swapping two values in db

From: Pascal Schmidt-Volkmar (pascalsv_at_nospam_tauth.com)
Date: 12/29/03

  • Next message: adze: "Re: renaming an mdb table from D7 using ADOX" 
    Date: Mon, 29 Dec 2003 08:21:34 +0100

    Hi there,

    I have entries in my db, each having a unique number. Now I would like to
    change two entries so they just swap their numbers.

    example: entry A with number 2
                    entry B with number 3

    later: entry A with number 3
                    entry B with number 2

    How could this be done? I tried a stored procedure but I failed because
    after changing the first of both values, the primary key was violated. Maybe
    I do need a third variable to store one of the two numbers....

    Thanks for any help!!

    Pascal

  • Next message: adze: "Re: renaming an mdb table from D7 using ADOX"

    Relevant Pages

    • Re: [rfd] function-graph augmentation
      ... It seemed useful to add argument/return tracer ... entries which, when found after a function entry, or function exit entry ... And interrupt can fill a lot of entries ... The other solution would be to have a hashtable of functions for which we want to store the ...
      (Linux-Kernel)
    • Re: Solving the lib mismatch problem
      ... This section is pointed to by an entry in the section table with the ... The number of entries in the table is determined by DT_VERDEFNUM. ... This is an index into the string section referenced in the section ... Offset in the string section reference by the link in the section ...
      (comp.unix.programmer)
    • Hollywood Book Festival - Call For Entries
      ... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
      (alt.fan.harry-potter)
    • Hollywood Book Festival - Call For Entries
      ... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
      (misc.writing)
    • Hollywood Book Festival - Call For Entries
      ... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
      (rec.arts.sf.starwars.misc)