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. Advertising

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:
    303
    =?Utf-8?B?QXJuZSBCZXJ1bGRzZW4=?=
    Jun 24, 2004
  2. nicholas
    Replies:
    2
    Views:
    389
    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,562
    Patrick.O.Ige
    Dec 13, 2005
  4. news.rcn.com
    Replies:
    2
    Views:
    1,107
    Roedy Green
    Dec 10, 2007
  5. Matthew Heidemann
    Replies:
    14
    Views:
    232
    eT Ma
    Mar 22, 2011
Loading...

Share This Page