Cara Mengaktifkan Module "rewrite" di Wamp

wamp tray icon --> apache --> apache module --> rewrite module

sumber : http://forum.wampserver.com/read.php?2,30758,30758

Format Ribuan di MySQL

SELECT REPLACE(REPLACE(REPLACE(FORMAT(pendapatan, 2), ".", "@"), ",", "."), "@", ",") as pendapatan FROM tgaji_rinci

Gambar hasil query di atas

Komponen ZQuery Jadi-jadian di Delphi

var Qf:TZQuery;
begin
  try
    Qf:=TZQuery.Create(nil);
    Qf.Connection:=ZConnection1;

    Qf.Close;
    Qf.SQL.Text:='';
    Qf.ExecSQL;
  except

    // do nothing
  end;
end;