Warning: include(themes/white/header.php) [function.include]: failed to open stream: Permission denied in /home/edysoft/public_html/delphi/index.php on line 9

Warning: include(themes/white/header.php) [function.include]: failed to open stream: Permission denied in /home/edysoft/public_html/delphi/index.php on line 9

Warning: include() [function.include]: Failed opening 'themes/white/header.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/edysoft/public_html/delphi/index.php on line 9
penjumlahan total dari no faktur yang sama
Rabu, 16 Maret 11 - oleh : srirahayu

pak, numpang tanya dong
kalau saya mau menampilkan hasil perhitungan totalpenjualan(edit.text) dari form lain berdasarkan no faktur yang sama bagaimana?? saya sudah coba kurang lebih seperti ini

SqlText:='select no_faktur,sum(subtotal) as total from penjualan where no_faktur :a';

dm.ADOpenjualan.Parameters.ParamByName('a').Value:=dm.ADOpenjualan['no_faktur'];

Jawab:

ada yang kurang yaitu group by

SqlText:='select no_faktur,sum(subtotal) as total from penjualan where no_faktur :a group by no_faktur';

  kirim ke teman |   versi cetak


Tidak ada komentar tentang artikel ini.

Formulir Komentar | Aturan >>

Nama
Nip.
Judul Komentar
Komentar

Warning: include(themes/white/footer.php) [function.include]: failed to open stream: Permission denied in /home/edysoft/public_html/delphi/index.php on line 40

Warning: include(themes/white/footer.php) [function.include]: failed to open stream: Permission denied in /home/edysoft/public_html/delphi/index.php on line 40

Warning: include() [function.include]: Failed opening 'themes/white/footer.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/edysoft/public_html/delphi/index.php on line 40