Hello Derek,
Thanks for your answer.
i changed the type of the field from real to currency and the issue is still there.
I've checked was has been saved in the database, and there the value is stored correctly so...perhaps the issue comes from the select statement I have.
My form contain 2 table grid views, one is with the articles and when i click on one article, the second table grid is populated with the right Bill of material.
My Select statement looks like this:
frmArticole.grdBOM.dbSQL := 'SELECT tblBom.id,BOMName,ArticleNo, ArticleName,Quantity,UmNo, ' +
' Case Active when 1 then "Da" when 0 then "Nu" End, ' +
' Case Fixed when 1 then "Da" when 0 then "Nu" End ' +
' from tblBOM ' +
'inner join tblArticol on tblBom.id_tblArticol1=tblArticol.id ' +
'inner join tblBomType on tblBom.id_tblBomType=tblBomType.id ' +
'inner join tblUm on tblBom.id_tblUM=tblUm.id ' +
'where id_tblArticol= '+ frmArticole.txtCODID.text + ;
frmArticole.grdBOM.dbListFieldsNames:='ID,Tip BOM, Nr. Articol, Nume Articol, Cantitate,UM, Activ? ,Fix?';
frmArticole.grdBOM.dbSQLExecute;
How can I change the Quantity in the select statement to show me the right value?
Thank you.
Br,
Alin
Best regards,
Alin