Database auto-update of the total quantity

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • edsbernardino
    New Member
    • Apr 2007
    • 4

    Database auto-update of the total quantity

    Hi everyone, i'm quite new to this forum. My dilemma goes like this..I wanted a program that will have 1 entry at a time and saved in a database. but the database will automatically calculate the total of the quantities i have entered. Everytime a user will transact to the program, the database will update as well as the quantities and total count. I havent decided yet on what backend DB to use..I'm a bit confused. thanks in advance for those who can help me...
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by edsbernardino
    Hi everyone, i'm quite new to this forum. My dilemma goes like this..I wanted a program that will have 1 entry at a time and saved in a database. but the database will automatically calculate the total of the quantities i have entered. Everytime a user will transact to the program, the database will update as well as the quantities and total count. I havent decided yet on what backend DB to use..I'm a bit confused. thanks in advance for those who can help me...
    I'd expect that an automatic update like this would be set up, if possible, in the database itself. If it's supported, that is. But that would depend on what back-end you use.

    Comment

    • edsbernardino
      New Member
      • Apr 2007
      • 4

      #3
      Originally posted by Killer42
      I'd expect that an automatic update like this would be set up, if possible, in the database itself. If it's supported, that is. But that would depend on what back-end you use.
      I intend to use excel as a backend..Now, is it possible that i'll have first a text file where the initial entry will be logged and then it will be transferred to the excel file, now including the subtotal of each column listed in one line?

      Comment

      Working...