Download - Praktikum Microsoft Visual Foxpro
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Tujuan : 1. Agar madyasiswa mengenal dan mengetahui penggunaan objec Combo Box dan Check Box.
2. Agar madyasiswa dapat membuat kode program yang berhubungan dengan objec (Combo Box & Check Box).
Logika :
Kita akan menampilkan gaji pokok dan total gaji karyawan. Dengan ketentuan diharuskan
memilih salah satu jabatan dan tunjangan, apakah Tunjangan Istri atau Tunjangan Anak.
Objec Check1 Procedure Click IF this.Value = 1
thisform.check2.Value = 0
ENDif
Objec Check2 Procedure Click IF this.Value = 1
thisform.check1.Value = 0
ENDif
Objec cmdhitung Procedure Click IF EMPTY(thisform.txtnama.Value)
=MESSAGEBOX("Anda belum mengisi nama karyawan",0+64,"Informasi")
RETURN
ENDIF
IF EMPTY(thisform.cbojabatan.Value)
=MESSAGEBOX("Anda belum memilih jabatan",0+64,"Informasi")
RETURN
ENDIF
IF Thisform.check1.Value=0 .and. Thisform.check2.Value=0
=MESSAGEBOX("Anda belum memilih Tunjangan",0+64,"Informasi")
RETURN
ENDIF
IF thisform.cbojabatan.Value ='Manager'
gp = 1500000
ELSE
IF thisform.cbojabatan.Value ='Staf'
gp = 1000000
ELSE
IF thisform.cbojabatan.Value ='Kasir'
gp = 7500000
ELSE
= MESSAGEBOX("Jabatan tersebut tidak terdaftar",0+64,"Info")
return
ENDif
ENDIF
endif
if thisform.check1.Value = 1
tj = 0.05 * gp
ELSE
tj = 0.10 * gp
endif
tg = gp + tj
thisform.txtgapok.Value = gp
thisform.txttotgaji.Value = tg
Combox
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Tujuan : 1. Agar madyasiswa mengenal dan mengetahui penggunaan objec Combo Box dan Check Box.
2. Agar madyasiswa dapat membuat kode program yang berhubungan dengan objec (Combo Box & Check Box).
Objec Check1 Procedure Click IF this.Value = 1
thisform.check2.Value = 0
thisform.check3.Value = 0
thisform.check4.Value = 0
ENDIF
Objec Check2 Procedure Click IF this.Value = 1
thisform.check1.Value = 0
thisform.check3.Value = 0
thisform.check4.Value = 0
ENDIF
Objec Check3 Procedure Click IF this.Value = 1
thisform.check4.Value = 0
ENDIF
IF this.Value = 1 .and. thisform.check1.Value = 1
thisform.txttjsuami.Enabled = .F.
thisform.txttjistri.Enabled = .T.
thisform.txttjanak.Enabled = .T.
ELSE
IF this.Value = 1 .and. thisform.check2.Value = 1
thisform.txttjsuami.Enabled = .T.
thisform.txttjanak.Enabled = .T.
thisform.txttjistri.Enabled = .F.
ENDIF
endif
Objec Check4 Procedure Click IF this.Value = 1
thisform.check3.Value = 0
thisform.txttjsuami.Enabled = .F.
thisform.txttjistri.Enabled = .F.
thisform.txttjanak.Enabled = .F.
ENDIF
Objec cmdproses Procedure Click a = thisform.txtnamakar.Value
b = thisform.check1.Value
c = thisform.check2.Value
d = thisform.check3.Value
e = thisform.check4.Value
f = thisform.cbojab.Value
IF EMPTY(a)
=MESSAGEbox("Nama karyawan belum diisi",0+64,"Info")
RETURN
ENDIF
If b = 0 .and. c = 0
=MESSAGEbox("Anda belum memilih jenis kelamin",0+64,"Info")
RETURN
Penanggung Jawab Mata Kuliah : Yanto Naim
ENDIF
IF EMPTY(f)
=MESSAGEbox("Anda belum memilih jabatan",0+64,"Info")
RETURN
ENDIF
If d = 0 .and. e = 0
=MESSAGEbox("Anda belum menentukan status",0+64,"Info")
RETURN
ENDIF
IF f = 'Manager'
IF b = 1 .and. d = 1
gp = 4000000
ELSE
IF c = 1 .and. d = 1
gp = 3250000
ELSE
IF b = 1 .and. e = 1
gp = 2000000
ELSE
IF c = 1 .and. e = 1
gp = 750000
ENDIF
ENDIF
ENDIF
ENDIF
ELSE
IF f = 'Staf'
IF b = 1 .and. d = 1
gp = 3000000
ELSE
IF c = 1 .and. d = 1
gp = 2250000
ELSE
IF b = 1 .and. e = 1
gp = 1000000
ELSE
IF c = 1 .and. e = 1
gp = 750000
ENDIF
ENDIF
ENDIF
ENDIF
ELSE
IF f = 'Kasir'
IF b = 1 .and. d = 1
gp = 1000000
ELSE
IF c = 1 .and. d = 1
gp = 750000
ELSE
IF b = 1 .and. e = 1
gp = 1000000
ELSE
IF c = 1 .and. e = 1
gp = 500000
ENDIF
ENDIF
ENDIF
ENDIF
ENDIF
ENDIF
endif
IF b = 1 .and. d = 1
Tji = gp * 0.15
Tja = gp * 0.20
Tg = gp + Tji + Tja
thisform.txtgapok.Value = gp
thisform.txttjistri.Value = Tji
thisform.txttjsuami.Value =''
thisform.txttjanak.Value = Tja
thisform.txttotgaji.Value = Tg
ELSE
IF c = 1 .and. d = 1
Tjs = gp * 0.10
Tja = gp * 0.20
Tg = gp + Tjs + Tja
thisform.txtgapok.Value = gp
thisform.txttjsuami.Value = Tjs
thisform.txttjistri.Value =''
thisform.txttjanak.Value = Tja
thisform.txttotgaji.Value = Tg
ELSE
thisform.txttjsuami.Value =''
thisform.txttjistri.Value =''
thisform.txttjanak.Value =''
thisform.txtgapok.Value = gp
thisform.txttotgaji.Value = gp
endif
ENDIF
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Visual Foxpro
Golongan :
IIA = Gapok Rp. 1.000.000,-
IIB = Gapok Rp. 2.000.000,-
IIC = Gapok Rp. 3.000.000,-
Tampilkan :
1. Gaji Pokok.
2. Total Gaji.
--------------------------------------------------------------------------------------------------------------------
Praktikum Visual Foxpro
Golongan :
IIA = Gapok Rp. 1.000.000,-
IIB = Gapok Rp. 2.000.000,-
IIC = Gapok Rp. 3.000.000,-
Tampilkan :
1. Gaji Pokok.
2. Total Gaji.
--------------------------------------------------------------------------------------------------------------------
Praktikum Visual Foxpro
Golongan :
IIA = Gapok Rp. 1.000.000,-
IIB = Gapok Rp. 2.000.000,-
IIC = Gapok Rp. 3.000.000,-
Tampilkan :
1. Gaji Pokok.
2. Total Gaji.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Tujuan : 1. Agar madyasiswa dapat membuat database dan tabel.
2. Agar madyasiswa dapat melakukan proses penyimpanan, pengeditan, & penghapusan data pada database.
Rancanglah database dan tabel dibawah ini :
Nama database : dbspenduduk
Nama tabel : tblkec
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Kecamatan, dibawah ini :
Objec Grid
Ketik Listing dibawah ini :
Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tblkec")
SELECT 1
USE tblkec EXCLUSIVE
ENDIF
thisform.txtkdkec.Value =''
thisform.txtnamakec.Value =''
thisform.txtnamakab.Value =''
thisform.txtnamakec.Enabled = .F.
thisform.txtnamakab.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txtkdkec.SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkdkec procedure Lostfocus
IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
Penanggung Jawab Mata Kuliah : Yanto Naim
SELECT tblkec
SET ORDER TO tag kdkec
LOCATE FOR kdkec=this.Value
IF FOUND()
thisform.txtkdkec.Value=kdkec
thisform.txtnamakec.Value =namakec
thisform.txtnamakab.Value =namakab
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
thisform.txtnamakec.Enabled = .T.
thisform.txtnamakab.Enabled = .T.
thisform.txtnamakec.SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Object cmdsimpan procedure Click
IF EMPTY(thisform.txtkdkec.Value)
=MESSAGEBOX("Kode Kecamatan belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtnamakec.Value)
=MESSAGEBOX("Nama Kecamatan belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtnamakab.Value)
=MESSAGEBOX("Nama Kabupaten belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tblkec
SET ORDER To tag kdkec
kode=ALLTRIM(thisform.txtkdkec.Value)
kec=ALLTRIM(thisform.txtnamakec.Value)
kab=ALLTRIM(thisform.txtnamakab.Value)
IF baru=0
INSERT INTO tblkec(kdkec,namakec,namakab) values(kode,kec,kab)
ELSE
UPDATE tblkec set namakec=kec,namakab=kab WHERE kdkec=kode
ENDIF
thisform.cmdbatal.Click
Object cmdedit procedure click
this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txtkdkec.Enabled = .F.
thisform.txtnamakec.Enabled = .T.
thisform.txtnamakab.Enabled = .T.
thisform.txtnamakec.SetFocus
Object cmdhapus procedure click
IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
ENDIF
SELECT tblkec
SET ORDER TO tag kdkec
DELETE
thisform.cmdbatal.Click
Object cmdbatal procedure click
thisform.txtkdkec.Value =''
thisform.txtnamakec.Value =''
thisform.txtnamakab.Value =''
thisform.txtnamakec.Enabled = .F.
thisform.txtnamakab.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txtkdkec.Enabled = .T.
thisform.txtkdkec.SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Tujuan : 1. Agar madyasiswa dapat membuat database dan tabel.
2. Agar madyasiswa dapat melakukan proses penyimpanan, pengeditan, & penghapusan data pada database.
Rancanglah database dan tabel dibawah ini :
Nama database : dbspasien
Nama tabel : tblpenyakit
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Penyakit, dibawah ini :
Objec Grid
Ketik Listing dibawah ini :
Objec Form Procedure Init SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tblpenyakit")
SELECT 1
USE tblpenyakit EXCLUSIVE
ENDIF
thisform.txtkdp.Value =''
thisform.txtnmp.Value =''
thisform.txtjp.Value =''
thisform.txtnmp.Enabled = .F.
thisform.txtjp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txtkdp.SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkdp procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
Penanggung Jawab Mata Kuliah : Yanto Naim
SELECT tblpenyakit
SET ORDER TO tag kdp
LOCATE FOR kdp=this.Value
IF FOUND()
thisform.txtkdp.Value=kdp
thisform.txtnmp.Value =nmp
thisform.txtjp.Value =jp
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
thisform.txtnmp.Enabled = .T.
thisform.txtjp.Enabled = .T.
thisform.txtnmp.SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform.txtkdp.Value)
=MESSAGEBOX("Kode Penyakit belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtnmp.Value)
=MESSAGEBOX("Nama Penyakit belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtjp.Value)
=MESSAGEBOX("Jenis penyakit belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tblpenyakit
SET ORDER To tag kdp
kd=ALLTRIM(thisform.txtkdp.Value)
py=ALLTRIM(thisform.txtnmp.Value)
jpy=ALLTRIM(thisform.txtjp.Value)
IF baru=0
INSERT INTO tblpenyakit(kdp,nmp,jp) values(kd,py,jpy)
ELSE
UPDATE tblpenyakit set nmp=py,jp=jpy WHERE kdp=kd
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txtkdp.Enabled = .F.
thisform.txtnmp.Enabled = .T.
thisform.txtjp.Enabled = .T.
thisform.txtnmp.SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
ENDIF
SELECT tblpenyakit
SET ORDER TO tag kdp
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform.txtkdp.Value =''
thisform.txtnmp.Value =''
thisform.txtjp.Value =''
thisform.txtnmp.Enabled = .F.
thisform.txtjp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txtkdp.Enabled = .T.
thisform.txtkdp.SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Tujuan : 1. Agar madyasiswa dapat membuat database dan tabel.
2. Agar madyasiswa dapat melakukan proses penyimpanan, pengeditan, & penghapusan data pada database.
Rancanglah database dan tabel dibawah ini :
Nama database : dbspenjualan
Nama tabel : tblpelanggan
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pelanggan, dibawah ini :
Objec Grid
Ketik Listing dibawah ini :
Objec Form Procedure Init SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tblpelanggan")
SELECT 1
USE tblpelanggan EXCLUSIVE
ENDIF
thisform.txtkodep.Value =''
thisform.txtnamap.Value =''
thisform.txtalamatp.Value =''
thisform.txtnamap.Enabled = .F.
thisform.txtalamatp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txtkodep.SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tblpelanggan
Penanggung Jawab Mata Kuliah : Yanto Naim
SET ORDER TO tag kodep
LOCATE FOR kodep=this.Value
IF FOUND()
thisform.txtkodep.Value=kodep
thisform.txtnamap.Value =namap
thisform.txtalamatp.Value =alamatp
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
thisform.txtnamap.Enabled = .T.
thisform.txtalamatp.Enabled = .T.
thisform.txtnamap.SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform.txtkodep.Value)
=MESSAGEBOX("Kode Pelanggan belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtnamap.Value)
=MESSAGEBOX("Nama Pelanggan belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtalamatp.Value)
=MESSAGEBOX("Alamat Pelanggan belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tblpelanggan
SET ORDER To tag kodep
kdp=ALLTRIM(thisform.txtkodep.Value)
nmp=ALLTRIM(thisform.txtnamap.Value)
alp=ALLTRIM(thisform.txtalamatp.Value)
IF baru=0
INSERT INTO tblpelanggan(kodep,namap,alamatp) values(kdp,nmp,alp)
ELSE
UPDATE tblpelanggan set namap=nmp,alamatp=alp WHERE kodep=kdp
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txtkodep.Enabled = .F.
thisform.txtnamap.Enabled = .T.
thisform.txtalamatp.Enabled = .T.
thisform.txtnamap.SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
ENDIF
SELECT tblpelanggan
SET ORDER TO tag kodep
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform.txtkodep.Value =''
thisform.txtnamap.Value =''
thisform.txtalamatp.Value =''
thisform.txtnamap.Enabled = .F.
thisform.txtalamatp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txtkodep.Enabled = .T.
thisform.txtkodep.SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblHargaBarang
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Harga Jual Barang, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblHargaBarang
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Harga Jual Barang, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblPemasok
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pemasok, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblPemasok
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pemasok, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblgudang
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Gudang, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblgudang
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Gudang, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblpetugas
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Petugas, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodept procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
Penanggung Jawab Mata Kuliah : Yanto Naim
baru=1
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblDesa
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Desa, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblDesa
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Desa, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblpropinsi
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Propinsi, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblpropinsi
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Propinsi, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblpenduduk
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Penduduk, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
Penanggung Jawab Mata Kuliah : Yanto Naim
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblmutasi
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Mutasi Penduduk, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
Penanggung Jawab Mata Kuliah : Yanto Naim
baru=1
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblkelahiran
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Kelahiran Penduduk, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
Penanggung Jawab Mata Kuliah : Yanto Naim
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tbllanjutusia
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Penduduk Lanjut Usia, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………………………")
SELECT 1
USE tbl………………………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =0
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =0
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtnik procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
Penanggung Jawab Mata Kuliah : Yanto Naim
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("……………………………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl……………………………………
SET ORDER To tag ……………………………………
…………………………=ALLTRIM(thisform. ……………………………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………………………….Value)
…………………………=thisform. ……………………………………………………………….Value
…………………………=ALLTRIM(thisform. ……………………………………………………………….Value)
…………………………=thisform. ……………………………………………………………….Value
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl……………………………………
SET ORDER TO tag ……………………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =0
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =0
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblPasien
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pasien, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblPasien
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pasien, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblObat
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Obat, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblObat
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Obat, dibawah ini :
Gunakan Listing di Form sebelumnya, ubah Listingnya sesuai dengan nama object, field dan tabel.
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tbldokter
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Dokter, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform.txt………………………….value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Enabled = .F.
thisform.txt………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txt………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform.txt………………………….Value =…………………………
thisform.txt………………………….Value =…………………………
thisform.txt………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
Penanggung Jawab Mata Kuliah : Yanto Naim
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform.txt………………………….Value)
=MESSAGEBOX("Kode …………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txt………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform.txt………………………….Value)
…………………………=ALLTRIM(thisform.txt………………………….Value)
…………………………=ALLTRIM(thisform.txt………………………….Value)
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………)
values(…………………………,…………………………,…………………………)
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txt………………………….Enabled = .F.
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform.txt………………………….Value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Enabled = .F.
thisform.txt………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblruangrawat
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Ruang Rawat Inap, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =0
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
Penanggung Jawab Mata Kuliah : Yanto Naim
baru=1
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=thisform. ……………………………………………….Value
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =0
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblrujukan
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Rujukan Pasien, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtnorujukan procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
Penanggung Jawab Mata Kuliah : Yanto Naim
baru=1
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=thisform. ……………………………………………….Value
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Praktikum Microsoft Visual Foxpro
Rancanglah tabel dibawah ini pada database sebelumnya :
Nama tabel : tblpasienigd
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pasien IGD, dibawah ini :
Format Penulisan Source Code : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform. ……………………………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtnopasien procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform. ……………………………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
Penanggung Jawab Mata Kuliah : Yanto Naim
baru=1
ELSE
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ……………………………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=ALLTRIM(thisform. ……………………………………………….Value)
…………………………=thisform. ……………………………………………….Value
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………,
…………………………,………………………… ) values(…………………………,…………………………,…………………………,
…………………………,………………………… )
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………,
…………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
return
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform. ……………………………………………….value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Value =''
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform. ……………………………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform. ……………………………………………….Enabled = .T.
thisform. ……………………………………………….SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Studi Kasus Sederhana – Praktikum Visual Foxpro – Pembuatan Laporan
Tujuan : 1. Agar madyasiswa dapat membuat database dan tabel.
2. Agar madyasiswa dapat melakukan proses penyimpanan, pengeditan, & penghapusan data pada database.
3. Agar madyasiswa dapat merancang dan membuat laporan.
Rancanglah database dan tabel dibawah ini :
Nama database : dbspasien
Nama tabel : tblpenyakit
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Penyakit, dibawah ini :
Objec Grid
cmdcetak
Ketik Listing dibawah ini :
Objec Form Procedure Init SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tblpenyakit")
SELECT 1
USE tblpenyakit EXCLUSIVE
ENDIF
thisform.txtkdp.Value =''
thisform.txtnmp.Value =''
thisform.txtjp.Value =''
thisform.txtnmp.Enabled = .F.
thisform.txtjp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txtkdp.SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkdp procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
RETURN
ENDIF
SELECT tblpenyakit
SET ORDER TO tag kdp
LOCATE FOR kdp=this.Value
IF FOUND()
thisform.txtkdp.Value=kdp
thisform.txtnmp.Value =nmp
thisform.txtjp.Value =jp
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
thisform.txtnmp.Enabled = .T.
thisform.txtjp.Enabled = .T.
thisform.txtnmp.SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform.txtkdp.Value)
=MESSAGEBOX("Kode Penyakit belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtnmp.Value)
=MESSAGEBOX("Nama Penyakit belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtjp.Value)
=MESSAGEBOX("Jenis penyakit belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tblpenyakit
SET ORDER To tag kdp
kd=ALLTRIM(thisform.txtkdp.Value)
py=ALLTRIM(thisform.txtnmp.Value)
jpy=ALLTRIM(thisform.txtjp.Value)
IF baru=0
INSERT INTO tblpenyakit(kdp,nmp,jp) values(kd,py,jpy)
ELSE
UPDATE tblpenyakit set nmp=py,jp=jpy WHERE kdp=kd
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txtkdp.Enabled = .F.
thisform.txtnmp.Enabled = .T.
thisform.txtjp.Enabled = .T.
thisform.txtnmp.SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
ENDIF
SELECT tblpenyakit
SET ORDER TO tag kdp
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform.txtkdp.Value =''
thisform.txtnmp.Value =''
thisform.txtjp.Value =''
thisform.txtnmp.Enabled = .F.
thisform.txtjp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txtkdp.Enabled = .T.
thisform.txtkdp.SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Studi Kasus Sederhana – Praktikum Visual Foxpro – Pembuatan Laporan
Tujuan : Agar madyasiswa dapat merancang dan membuat laporan.
Buat Form – simpan dengan nama FrmLaporan
Check1
Check2
Rancanglah Laporan Penyakit seperti desain laporan pada report dibawah ini, simpan dengan nama :
rptpenyakit
Ketik listing pencetakkan dibawah ini :
Objec cmdcetak procedure click SELECT kdp,nmp;
from ;
dbspasien!tblpenyakit;
INTO CURSOR penyakit
SELECT penyakit
GO top
IF EOF()
=MESSAGEBOX("Data Penyakit tidak ada !",0+16,"Informasi")
RETURN
ENDIF
REPORT FORM rptpenyakit preview
if used('penyakit')
use in penyakit
ELSE
DELETE FILE penyakit.*
ENDIF
Hasil desain ketika dijalankan sebagai berikut :
Field :
Penyakit.kdp Field :
Penyakit.nmp
Penanggung Jawab Mata Kuliah : Yanto Naim
Studi Kasus Sederhana – Praktikum Visual Foxpro – Pembuatan Laporan
Tujuan : 1. Agar madyasiswa dapat membuat database dan tabel.
2. Agar madyasiswa dapat melakukan proses penyimpanan, pengeditan, & penghapusan data pada database.
3. Agar madyasiswa dapat merancang dan membuat laporan.
Rancanglah database dan tabel dibawah ini :
Nama database : dbspenjualan
Nama tabel : tblpelanggan
Struktur tabel, sebagai berikut :
Rancanglah Form Entry Data Pelanggan, dibawah ini :
Objec Grid
CmdCetak
Ketik Listing dibawah ini :
Objec Form Procedure Init SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tblpelanggan")
SELECT 1
USE tblpelanggan EXCLUSIVE
ENDIF
thisform.txtkodep.Value =''
thisform.txtnamap.Value =''
thisform.txtalamatp.Value =''
thisform.txtnamap.Enabled = .F.
thisform.txtalamatp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txtkodep.SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
Penanggung Jawab Mata Kuliah : Yanto Naim
SELECT tblpelanggan
SET ORDER TO tag kodep
LOCATE FOR kodep=this.Value
IF FOUND()
thisform.txtkodep.Value=kodep
thisform.txtnamap.Value =namap
thisform.txtalamatp.Value =alamatp
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
thisform.txtnamap.Enabled = .T.
thisform.txtalamatp.Enabled = .T.
thisform.txtnamap.SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform.txtkodep.Value)
=MESSAGEBOX("Kode Pelanggan belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtnamap.Value)
=MESSAGEBOX("Nama Pelanggan belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txtalamatp.Value)
=MESSAGEBOX("Alamat Pelanggan belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tblpelanggan
SET ORDER To tag kodep
kdp=ALLTRIM(thisform.txtkodep.Value)
nmp=ALLTRIM(thisform.txtnamap.Value)
alp=ALLTRIM(thisform.txtalamatp.Value)
IF baru=0
INSERT INTO tblpelanggan(kodep,namap,alamatp) values(kdp,nmp,alp)
ELSE
UPDATE tblpelanggan set namap=nmp,alamatp=alp WHERE kodep=kdp
ENDIF
thisform.cmdbatal.Click
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txtkodep.Enabled = .F.
thisform.txtnamap.Enabled = .T.
thisform.txtalamatp.Enabled = .T.
thisform.txtnamap.SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
ENDIF
SELECT tblpelanggan
SET ORDER TO tag kodep
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform.txtkodep.Value =''
thisform.txtnamap.Value =''
thisform.txtalamatp.Value =''
thisform.txtnamap.Enabled = .F.
thisform.txtalamatp.Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txtkodep.Enabled = .T.
thisform.txtkodep.SetFocus
Penanggung Jawab Mata Kuliah : Yanto Naim
Studi Kasus Sederhana – Praktikum Visual Foxpro – Pembuatan Laporan
Tujuan : Agar madyasiswa dapat merancang dan membuat laporan.
Buat Form – simpan dengan nama FrmLaporan
Check1
Check2
Rancanglah Laporan Pelanggan seperti desain laporan pada report dibawah ini, simpan dengan nama :
rptpelanggan
Ketik listing pencetakkan dibawah ini :
Objec cmdcetak procedure click ch1 = thisform.check1.Value
IF ch1 = 1
SELECT kodep,namap,alamatp;
from ;
dbspenjualan!tblpelanggan;
INTO CURSOR pelanggan
SELECT pelanggan
GO top
IF EOF()
=MESSAGEBOX("Data pelanggan tidak ada !",0+16,"Informasi")
RETURN
ENDIF
REPORT FORM rptpelanggan preview
if used('pelanggan')
use in pelanggan
ELSE
DELETE FILE pelanggan.*
ENDIF
ENDIF
Hasil desain ketika dijalankan sebagai berikut :
Field :
Pelanggan.Kodep Field :
Pelanggan.namap
Field :
Pelanggan.alamatp
Penanggung Jawab Mata Kuliah : Yanto Naim
Studi Kasus Sederhana – Praktikum Visual Foxpro – Pembuatan Laporan
Tujuan : Agar madyasiswa dapat merancang dan membuat laporan.
Buat Form – simpan dengan nama FrmLaporan
Check1
Check2
Rancanglah Laporan Kecamatan seperti desain laporan pada report dibawah ini, simpan dengan nama :
rptkecamatan
Ketik listing pencetakkan dibawah ini :
Objec cmdcetak procedure click ch1 = thisform.check1.Value
IF ch1 = 1
SELECT kdkec,namakec,namakab;
from ;
dbspenduduk!tblkec;
INTO CURSOR kecamatan
SELECT kecamatan
GO top
IF EOF()
=MESSAGEBOX("Data Kecamatan tidak ada !",0+16,"Informasi")
RETURN
ENDIF
REPORT FORM rptkecamatan preview
if used('kecamatan')
use in kecamatan
ELSE
DELETE FILE kecamatan.*
ENDIF
ENDIF
Hasil desain ketika dijalankan sebagai berikut :
Field :
Kecamatan.Kdkec Field :
Kecamatan.namakec
Field :
Kecamatan.namakab
Penanggung Jawab Mata Kuliah : Yanto Naim
Studi Kasus Sederhana – Praktikum Visual Foxpro – Pembuatan Laporan
Tujuan : Agar madyasiswa dapat merancang dan membuat laporan.
Buat Form – simpan dengan nama FrmLaporan
Check1
Check2
Rancanglah Laporan Kecamatan seperti desain laporan pada report dibawah ini, simpan dengan nama :
rptkecamatan
Ketik listing pencetakkan dibawah ini :
Objec cmdcetak procedure click ch1 = thisform.check1.Value
IF ch1 = 1
SELECT kdkec,namakec,namakab;
from ;
dbspenduduk!tblkec;
INTO CURSOR kecamatan
SELECT kecamatan
GO top
IF EOF()
=MESSAGEBOX("Data Kecamatan tidak ada !",0+16,"Informasi")
RETURN
ENDIF
REPORT FORM rptkecamatan preview
if used('kecamatan')
use in kecamatan
ELSE
DELETE FILE kecamatan.*
ENDIF
ENDIF
Hasil desain ketika dijalankan sebagai berikut :
Field :
Kecamatan.Kdkec Field :
Kecamatan.namakec
Field :
Kecamatan.namakab
Penanggung Jawab Mata Kuliah : Yanto Naim
Format Penulisan : Objec Form Procedure Init
SET TALK OFF
SET DELETE on
SET EXCLUSIVE on
SET EXACT ON
IF !USED("tbl…………………………")
SELECT 1
USE tbl………………………… EXCLUSIVE
ENDIF
thisform.txt………………………….value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Enabled = .F.
thisform.txt………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.txt………………………….SetFocus
Objec Form procedure Load
PUBLIC baru
baru =0
Objec txtkodep procedure Lostfocus IF EMPTY(this.Value)
this.SetFocus
RETURN
ENDIF
SELECT tbl
SET ORDER TO tag ………………………
LOCATE FOR ………………=this.Value
IF FOUND()
thisform.txt………………………….Value=…………………………
thisform.txt………………………….Value =…………………………
thisform.txt………………………….Value =…………………………
thisform.cmdedit.Enabled= .T.
thisform.cmdhapus.Enabled=.t.
baru=1
ELSE
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….SetFocus
baru=0
thisform.cmdsimpan.Enabled=.t.
ENDIF
Objec cmdsimpan procedure Click IF EMPTY(thisform.txt………………………….Value)
=MESSAGEBOX("Kode …………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform.txt………………………….Value)
=MESSAGEBOX("…………………………belum diisi",0+64,"Info")
RETURN
ENDIF
IF EMPTY(thisform. ………………………….Value)
=MESSAGEBOX("………………………… belum diisi",0+64,"Info")
RETURN
ENDIF
SELECT tbl…………………………
SET ORDER To tag …………………………
…………………………=ALLTRIM(thisform.txt………………………….Value)
…………………………=ALLTRIM(thisform.txt………………………….Value)
…………………………=ALLTRIM(thisform.txt………………………….Value)
IF baru=0
INSERT INTO tbl………………………… (…………………………,…………………………,…………………………)
values(…………………………,…………………………,…………………………)
ELSE
UPDATE tbl………………………… set …………………………=…………………………,…………………………=…………………………
WHERE …………………………=…………………………
ENDIF
thisform.cmdbatal.Click
Penanggung Jawab Mata Kuliah : Yanto Naim
Objec cmdedit procedure click this.Enabled = .F.
thisform.cmdsimpan.Enabled = .T.
baru = 1
thisform.txt………………………….Enabled = .F.
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….SetFocus
Objec cmdhapus procedure click IF MESSAGEBOX("Data ini mau dihapus?",4+32,"Konfirmasi")=7
thisform.cmdbatal.Click
ENDIF
SELECT tbl…………………………
SET ORDER TO tag …………………………
DELETE
thisform.cmdbatal.Click
Objec cmdbatal procedure click thisform.txt………………………….Value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Value =''
thisform.txt………………………….Enabled = .F.
thisform.txt………………………….Enabled = .F.
thisform.cmdsimpan.Enabled = .F.
thisform.cmdedit.Enabled = .F.
thisform.cmdhapus.Enabled = .F.
thisform.Refresh
thisform.txt………………………….Enabled = .T.
thisform.txt………………………….SetFocus