1 (edited by agusecc 2024-10-08 04:29:38)

Topic: I need script query sum for (Real)

I try use sql query sum for Real NOT Integer   but can't display in table grid.  anyone please help me..

(select sum (Real) from attendancedays where employees.id = attendancedays.id_employees ) as Terlambat

2 (edited by StateOne 2024-10-08 04:23:46)

Re: I need script query sum for (Real)

(select sum(Real) from attendancedays where employees.id = attendancedays.id_employees ) as Terlambat

Re: I need script query sum for (Real)

any solution?

Re: I need script query sum for (Real)

agusecc wrote:

any solution?


Show the full example program.

5 (edited by agusecc 2024-10-08 09:24:46)

Re: I need script query sum for (Real)

this is my project.
Thanks your attantion sparrow
https://www.mediafire.com/file/065az84r … y.rar/file

Post's attachments

Attachment icon rekap.png 36.72 kb, 28 downloads since 2024-10-08 

Re: I need script query sum for (Real)

This line in the script is wrong

tnxnumbercolumn (FormRekapGaji.TableGrid1.columns[10]).formatmask := '###,##0';

Re: I need script query sum for (Real)

Thanks, Sparrow... my project Solved