Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    2

    Unanswered: Deduct a Quantity of an SKU from one db to the next Database...

    hi,
    currently we have some shipping software that has a mqsql database locally.There are filters on the program and when an item is shipped from our warehouse it goes into a filter "Shipped".We have a SKU and also quantity for the product.

    Now we have an inventory program that also has a mqsql database,this has the same SKU as the shipping software database.what we hope to do is when an SKU is shipped in our software program(ie it Goes into the "Shipped" folder),it will deduct the quantity from the adjacent SKU in the inventory program database.

    Note that the 2 databases are independent from each other but would like them to be in effect linked to each other.


    Thanks in advance for any comments!!

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    If you're working in MySQL, you probably want to try posing this question on the MySQL forum...
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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