ADotable Trivial Question

[2710]

adoquery1.SQL.Clear;
adoquery1.SQL.Add('Update Stock');
adoquery1.SQL.Add('Set StockLeft = '+ (adotable2['StockLeft']-1));
adoquery1.SQL.Add('Where PLUNumber = 15');
adoquery1.execsql;

I have a table of stocks. I want it so that every time I execute this code, it decreases the stock with PLUNumber 15 by 1. So I tried doing

adotable2['StockLeft']-1

in the hope that it will read the 'Stockleft' WHERE the PLUnumber is 15 (and not the Sotckleft of the other stocks) and then decrease it. But It is not working.

I could create a procedure before this to work out the value of the StockLeft first, but this is just long.

Any solutions

Thanks

[WingedPanther]

adoquery1.SQL.Clear;
adoquery1.SQL.Add('Update Stock');
adoquery1.SQL.Add('Set StockLeft = StockLeft-1');
adoquery1.SQL.Add('Where PLUNumber = 15');
adoquery1.execsql;

[2710]

Omg Lol, thank you >__>

[Firebird_38]

What you were doing was adding an integer to a string.
It would'a worked if you'da did

adoquery1.SQL.Add('Set StockLeft = '+ IntToStr(adotable2['StockLeft']-1));

But this is not as good, because what's up above there is pure SQL, which means the DB server/system does the read/decrement/write without any help from the program. Plus it takes shorter, which is better for your DB integrity and such.
But now you know how to append numbers to strings.