Hello everyone, right now i'm trying to practice some lazarus-mysql programming, and i have some questions, can i filter the conditions
For example, like from this table
| Size | Deviation |
1.| 80 | 30 |
2.| 100 | 40 |
(Sorry for the crude table)
I need to calculate the ones with size 80 in this way:
if the size is 80 and deviation <= 10, then result = (deviation)*1000), otherwise
if deviation <=20 then result = (deviation-10)*2000 + 10*1000.
and
if deviation >=21 then result = (deviation-20)*3000 + 10*2000 +10*1000
And if the size is 100, it will be:
if the size is 100 and deviation <= 10, then result = (deviation)*2000, otherwise
if deviation <=20 then result = (deviation-10)*3000 + 10*2000
and
if deviation >=21 then result = (deviation-20)*4000 + 10*3000 +10*2000
How can i make lazarus to be able to do this?
I can do this on freepascal and without the datas from sql
but on this, i'm very confused
I am really confused right now
I'm using win7 x64 and lazarus 0.9.30 and FPC 2.6.0
Thanks in advance
Regards, malvinvnv