Increase counter when same product given

[shod90]

Dear Gents,
Currently Um working on cashier system but facing a little bit annoying issue
I need to make the program to be more smart in order to be easy for users.
Now if the cashier man passes 1 product 2 times i need to make the program automatically detect that this was same product and increase the qty to be 2 not making another line and make the qty. 1
is it possible ?

[andy49]

Do you mean...

Test if the product is the same as the previous row and if so change the previous row quantity to 2


Sent from my iPhone using Tapatalk

[shod90]

Yes Exactly , But not a rule if the previous row only is same , I need to check the whole records in same order number.
example:
Product 1 ----- qty 1
product 2 ----- qty 1
product 1 ----- qty 1

i need to make it as follows

product 1 --- qty 2
product 2 --- qty 1


I hope you understand the idea .

[andy49]

Sounds like you need a grouped query?


Sent from my iPhone using Tapatalk

[orange]

I agree you need a Group BY query in the logic to review the contents of the shoppingCart.
Sometimes there is a special eg $1.39 each or 3 for $3.00.

Shopping cart could be a Temp table or an Array