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

  • Registered: 2015-12-19
  • Posts: 145

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 Reply by StateOne (edited by StateOne 2024-10-08 04:23:46)

  • Registered: 2022-01-26
  • Posts: 85

Re: I need script query sum for (Real)

(select sum(Real) from attendancedays where employees.id = attendancedays.id_employees ) as Terlambat
  • Registered: 2015-12-19
  • Posts: 145

Re: I need script query sum for (Real)

any solution?

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,369

Re: I need script query sum for (Real)

agusecc wrote:

any solution?


Show the full example program.

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

  • Registered: 2015-12-19
  • Posts: 145

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, 59 downloads since 2024-10-08 

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,369

Re: I need script query sum for (Real)

This line in the script is wrong

tnxnumbercolumn (FormRekapGaji.TableGrid1.columns[10]).formatmask := '###,##0';
  • Registered: 2015-12-19
  • Posts: 145

Re: I need script query sum for (Real)

Thanks, Sparrow... my project Solved