PB entry window, how to realize the main health at the time of entry data data, save the number will be automatically accumulate (additive quantity,)

CodePudding user response:

This seemingly directly with data Windows update method of yo, statement judge perform it line by line,

CodePudding user response:

If all lines will display in the same dw, can use the find () to find the same value, numerical accumulative
If the line may not be DW, only to select a value from the table, if you have the update table or insert

CodePudding user response:

Can be solved on the database side go, home use triggers, repeat the update sl sl +=..
Don't repeat the insert

CodePudding user response:

If too much input data in the data window cycle will be slow, or on the database side will have better solution