Updating a Record using a current record

Discussion in 'ASP .Net' started by MRW, Feb 11, 2008.

  1. MRW

    MRW Guest

    Hello,

    I'm trying to make an inventory database. When a product is being
    shipping, I want to take the current QTY and minus 1 (for example) for
    each product being shipped.

    I know I can connect to the database by ProductID, use a reader, grab
    the QTY, close the reader, do QTY=QTY-1, then send an update query for
    all products in that cart.

    However, I'm sure there is an easier way of doing this. Does anybody
    have any suggestions?

    Thanks for any help!
     
    MRW, Feb 11, 2008
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?QXJuZSBCZXJ1bGRzZW4=?=

    Updating Record

    =?Utf-8?B?QXJuZSBCZXJ1bGRzZW4=?=, Jun 24, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    320
    =?Utf-8?B?QXJuZSBCZXJ1bGRzZW4=?=
    Jun 24, 2004
  2. nicholas
    Replies:
    2
    Views:
    407
    nicholas
    Apr 22, 2005
  3. barret bonden

    Current Recordset does not support updating.

    barret bonden, Dec 12, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    8,770
    Patrick.O.Ige
    Dec 13, 2005
  4. news.rcn.com
    Replies:
    2
    Views:
    1,214
    Roedy Green
    Dec 10, 2007
  5. Matthew Heidemann
    Replies:
    14
    Views:
    278
    eT Ma
    Mar 22, 2011
Loading...

Share This Page