Hi
I have a problem with datagrid1.
Downloading data through Adodc1 but I can not add another column in which if in column1 I have 01 in the added column gives me 100 if 02 is 200, 03 is 500, 04 is 70
The query from the database I have suchCode:select SUBSTR (number, 1,2), SUM (ILOSC) FROM my data WHERE status = '200' AND city = 'Wroclaw' GROUP BY SUBSTR (number, 1,2), ILOSC ORDER BY SUBSTR ( number, 1,2) ASC