Problem adding records in GRID

[Rolando2018]

Hi there, I would like you to help me solve this, please:



What I need is that when the same products are added, that new ones are not added, but rather that they are added. I am using SQLite 3.


This is the code I have to enter products by barcode:

b = Input.GetText("barcode");

if b > "1000000" and b <= "9999999" then

for row in db:nrows("SELECT * FROM Products where Code="..b.."") do

if b == (row.Code) then

Input.SetText("barcode", "");
Page.SetFocus("barcode")

nRowID = Grid.InsertRow("GridSales", -1, false);
Grid.SetCellText("GridSales", nRowID, 0, row.Code, false);
Grid.SetCellText("GridSales", nRowID, 1, row.Name, false);
Grid.SetCellText("GridSales", nRowID, 2, row.SalePrice, false);
Grid.SetCellText("GridSales", nRowID, 3, "1", false);
Grid.SetCellText("GridSales", nRowID, 4, "0", false);



--Column 2 * Column 3 = Column 4

value = Grid.GetCellText("GridSales", nRowID, 2);
amount = Grid.GetCellText("GridSales", nRowID, 3);
multiplication = value * amount;
Grid.SetCellText("GridSales", nRowID, 4, multiplication, true);



--Column 4 (Sum)

cell_value = 0;
for x = 1, Grid.GetRowCount ("GridSales")-1 do
if Grid.GetCellText ("GridSales", x, 4) ~= "" and String.ToNumber(Grid.GetCellText ("GridSales", x, 4)) ~= 0 then
cell_value = cell_value + String.ToNumber (Grid.GetCellText ("GridSales", x, 4))
end
end
Input.SetText("total", Math.Round(cell_value, false));




--************************************************** ********************************
Grid.SetEnabled("GridSales", true);
Grid.Refresh("GridVentas");

--************************************************** *******************************

end
end
end

Thanks.


-----


I don't speak English, I used Google Translate.

[Rolando2018]

I need you to increase the quantity when same products are added.

[colc]

I think you will have to post an example apz with database attached for someone to look at.
At the moment you are selecting from database and just adding a new line to grid ???,
should be adding to database with a record id

[Rolando2018]

I think you will have to post an example apz with database attached for someone to look at.
At the moment you are selecting from database and just adding a new line to grid ???,
should be adding to database with a record id

That's right, I am adding each record in the last Row.
But I don't think it is necessary to publish the apz, since with the code that I leave above it is more than enough (I think).

[Rolando2018]

I think you will have to post an example apz with database attached for someone to look at.
At the moment you are selecting from database and just adding a new line to grid ???,
should be adding to database with a record id

I share the project so that you can help me. I removed unnecessary things.

Thanks!

[colc]

I share the project so that you can help me. I removed unnecessary things.

After many hours of work, as I do not use Gtrid Objects I think I have found your solution
It would be much better if Grid had a Get Selected and Set Selected function
See if this works for you
Copy of Ronaldo2018_Project.apz

[Rolando2018]

After many hours of work, as I do not use Gtrid Objects I think I have found your solution
It would be much better if Grid had a Get Selected and Set Selected function
See if this works for you

Wow friend, of course it works for me. And your time to help me is greatly appreciated. Thank you so so so much!

---

I realized that when I add a product and then another product, and add the first one again, an error occurs. But I'll give it a spin, if I fix it I'll post it here. Greetings, friend. (Google translate)

[colc]

I have no probs with the copy I posted

[Rolando2018]

I have no probs with the copy I posted

At one point it begins to increase the amount by 2.

[Rolando2018]

I have no probs with the copy I posted

COLC made some changes and it worked very well. For those who want it, here it is.

All credits to him.