Monday, 5 November 2012
koding program stored dan function
DELIMITER $$
DROP FUNCTION IF EXISTS `toko_dbc110091`.`getKodepenjualan`$$
CREATE FUNCTION `toko_dbc110091`.`getKodepenjualan`(vTgl_pinjam DATETIME)
RETURNS VARCHAR(10)
DETERMINISTIC
BEGIN
DECLARE vthn CHAR(2);
DECLARE vbln CHAR(2);
DECLARE vtgl CHAR(2);
DECLARE vUrut INT;
SET vthn=SUBSTR(vTgl_pinjam,3,4);
SET vbln=SUBSTR(vTgl_pinjam,6,6);
SET vtgl=SUBSTR(vTgl_pinjam,9,9);
SELECT IFNULL (MAX(CAST(SUBSTR(Kode_Penjualan, 4, 5) AS UNSIGNED)),0)
FROM detail_penjualan
WHERE vtgl_pinjam LIKE CONCAT (vthn, vbln, vtgl, '%')INTO vUrut;
RETURN CONCAT (vthn, vbln,vtgl, vUrut+1);
END$$
DELIMITER ;
coding program kalkulator dalam bahasa delphi
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.TambahClick(Sender: TObject);
var EdJumlah : integer;
begin
EdJumlah := StrToInt(Bil_1.Text)+StrToInt(Bil_2.Text);
jml.Text := IntToStr(EdJumlah);
end;
procedure TForm1.KurangClick(Sender: TObject);
var edjumlah : integer;
begin
EdJumlah := StrToInt(Bil_1.Text)-StrToInt(Bil_2.Text);
jml.Text := IntToStr(EdJumlah);
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
if (application.MessageBox('Anda yakin keluar dari program','Information',mb_yesno)=idyes) then
close;
end;
procedure TForm1.BagiClick(Sender: TObject);
var edjumlah : real;
bil1,bil2 : real;
begin
bil1 := StrToFloat(Bil_1.Text);
bil2 := StrToFloat(bil_2.Text);
EdJumlah := bil1/bil2;
jml.Text := FloatToStr(EdJumlah);
end;
procedure TForm1.KaliClick(Sender: TObject);
var edjumlah : integer;
begin
EdJumlah := StrToInt(Bil_1.Text)*StrToInt(Bil_2.Text);
jml.Text := IntToStr(EdJumlah);
end;
procedure TForm1.div1Click(Sender: TObject);
var edjumlah : integer;
begin
EdJumlah := StrToInt(Bil_1.Text) div StrToInt(Bil_2.Text);
jml.Text := IntToStr(EdJumlah);
end;
procedure TForm1.mod1Click(Sender: TObject);
var edjumlah : integer;
begin
EdJumlah := StrToInt(Bil_1.Text) mod StrToInt(Bil_2.Text);
jml.Text := IntToStr(EdJumlah);
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
bil_1.Clear;
bil_2.Clear;
Jml.Clear;
end;
procedure TForm1.Button3Click(Sender: TObject);
var edjumlah : integer;
begin
EdJumlah := StrToInt(Bil_1.Text) * StrToInt(Bil_1.Text);
jml.Text := IntToStr(EdJumlah);
end;
end.
Subscribe to:
Posts (Atom)