Судя по всему вопрос по Mysql51Connect. Хотя я не уверен.
По порядку
Lazarus 0.9.31 fpc 2.5.1 Ubuntu
простой проект - на форме MySQL51Connect, SQLTransaction, SQLQuery, Datasource, DBGrid.
В SQLQuery установлен запрос:
- Код: Выделить всё
SELECT p.id, pn.name as name,pm.name as material, pct.type, pc.weightcount, pc.cost, (pc.weightcount*pc.cost) as sum, p.state, p.datestart, p.dateend, p.summ_delivery, (p.summ_delivery+percent_loan+percent_storadge) as summ_return, ps.percent as percentstoradge, p.percent_storadge as sumstoradge, pl.percent as percentloan, p.percent_loan as sumloan,c.name as client_name, c.surname, c.patronymic, c.inn, c.series, pc.weightbrutto, c.number as passportnumber, c.passportdate, c.uvd, c.residence, d.number as discount, CONCAT_WS("-",p.id_lbard,p.contract_number) as contract FROM pledge as p left join pledgecontent as pc ON (p.id = pc.id_pledge) left join pledgename as pn ON (pc.id_pledgename = pn.id) left join pledgematerial as pm ON (pc.id_pledgematerial = pm.id) left join pledgecost as pct ON (pc.id_pledgecost = pct.id) left join percent as pl ON (p.id_percent_loan = pl.id) left join percentstoradge as ps ON (p.id_percent_storadge = ps.id) left join clients as c ON (p.id_clients = c.id) left join discount as d ON (p.id_discount = d.id) WHERE p.id_lbard=1 AND p.state="OK"
В ДБгрид попадает только 18 полей из таблицы. Запрос отрабатывается без ошибок. Откуда такое ограничение? Куда копать?
В версии 0.9.28 отрабатывало на ура...
Добавлено спустя 7 часов 1 минуту 10 секунд:
Определил уточнение - не выбираются поля с типом decimal. Запрос
- Код: Выделить всё
select * from tblname
