Sunday, November 12, 2006

CONTOH PROGRAM VFOXPRO DENGAN SQL SERVER

Buatlah Tabel dengan nama Hotel di SERVER anda dengan menggunakan MySql>
Structure nya seperti dibawah ini
mysql> desc hotel;
+--------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| kode | char(5) | YES | | NULL | |
| nama | char(10) | YES | | NULL | |
| kelas | char(10) | YES | | NULL | |
| biaya | int(6) | YES | | NULL | |
| lama | int(2) | YES | | NULL | |
| diskon | int(6) | YES | | NULL | |
| total | int(8) | YES | | NULL | |
+--------+----------+------+-----+---------+-------+
7 rows in set (0.01 sec)

----------------------------------------------------
Object : Form1 Procedure: Activate
----------------------------------------------------
mstrl ="Driver={MySQL ODBC 3.51 Driver}"+;
";Server=192.168.10.253"+;
";Database="+"setyo"+;
";Uid="+"setyo"+;
";Pwd="+""
koneksi=SQLSTRINGCONNECT(mstrl)
SQLEXEC(koneksi,'select * from hotel','baru')

Thisform.judulgrid
thisform.pasif
-------------------------------------------------
Object : Form1 Procedure: Load
--------------------------------------------------
mstrl ="Driver={MySQL ODBC 3.51 Driver}"+;
";Server=192.168.10.253"+;
";Database="+"setyo"+;
";Uid="+"setyo"+;
";Pwd="+""
koneksi=SQLSTRINGCONNECT(mstrl)
-------------------------------------------------
Object : Form1 Procedure: Init
----------------------------------------------------
PUBLIC tombol,koneksi
------------------------------------------

----------------------------------------------
Object : Form1 Procedure: Aktif
-------------------------------------------
thisform.txtkode.enabled=.t.
thisform.txtnama.enabled=.t.
thisform.cbokelas.enabled=.t.
thisform.txtbiaya.enabled=.t.
thisform.txtlama.enabled=.t.
thisform.txtdiskon.enabled=.t.
thisform.txttotal.enabled=.t.
-------------------------------------------
Object : Form1 Procedure: Bersih
----------------------------------------------
thisform.txtkode.Value=''
thisform.txtnama.Value=''
thisform.cbokelas.value=''
thisform.txtbiaya.Value=0
thisform.txtlama.Value=0
thisform.txtdiskon.value=0
thisform.txttotal.value=0
---------------------------------------------------
Object : Form1 Procedure: Judulgrid
-------------------------------------------------
SQLEXEC(koneksi,'select * from hotel','baru')
thisform.grid1.RecordSourceType = 1
thisform.grid1.ColumnCount = 7
thisform.grid1.Column1.header1.caption='Kode Kamar'
thisform.grid1.Column1.width = 70
thisform.grid1.Column2.header1.caption='Nama Anggota'
thisform.grid1.Column2.width = 100
thisform.grid1.Column3.header1.caption='Kelas'
thisform.grid1.Column3.width = 70
thisform.grid1.Column4.header1.caption='Biaya'
thisform.grid1.Column3.width = 10
thisform.grid1.Column3.header1.caption='lama'
thisform.grid1.Column3.width = 70
thisform.grid1.Column3.header1.caption='Diskon'
thisform.grid1.Column3.width = 100
thisform.grid1.Column3.header1.caption='Total'
thisform.grid1.Column3.width = 100
thisform.grid1.RecordSource='baru'
----------------------------------------------
Object : Form1 Procedure: Pasif
---------------------------------------------
thisform.txtkode.enabled=.f.
thisform.txtnama.enabled=.f.
thisform.cbokelas.enabled=.f.
thisform.txtbiaya.enabled=.f.
thisform.txtlama.enabled=.f.
thisform.txtdiskon.enabled=.f.
thisform.txttotal.enabled=.f.
----------------------------------------------
Object : Form1 Procedure: Tampil
--------------------------------------------------
thisform.txtkode.Value=kode
thisform.txtnama.Value=nama
thisform.cbokelas.value=kelas
thisform.txtbiaya.Value=biaya
thisform.txtlama.Value=lama
thisform.txtdiskon.value=diskon
thisform.txttotal.value=total
-------------------------------------
object : txtnama Procedure: Gotfocus
--------------------------------------
SQLEXEC(koneksi,'select * from hotel','baru')
xno=ALLTRIM(thisform.txtkode.Value)
sql="select * from hotel where kode='&xno'"
SQLEXEC(koneksi, sql,'baru')

IF tombol=1
IF ! EMPTY(baru.kode)
thisform.tampil
thisform.judulgrid
MESSAGEBOX('Data Sudah ada')
thisform.bersih
thisform.txtkode.Value=''
thisform.txtkode.setfocus
thisform.aktif

ELSE
thisform.txtnama.SetFocus
thisform.judulgrid
ENDIF
endif

IF tombol=2
IF EMPTY(baru.kode)
MESSAGEBOX('Data tidak ada')
thisform.txtkode.Value=''
thisform.txtkode.setfocus
ENDIF

IF ! EMPTY(baru.kode)
thisform.tampil
thisform.txtkode.Enabled= .F.
thisform.judulgrid
thisform.aktif
thisform.txtnama.SetFocus
ENDIF
ENDIF

IF tombol=4
IF ! EMPTY(baru.kode)
thisform.tampil
IF MESSAGEBOX('yakin data mau dihapus',1+32)=1
msql='delete from hotel where kode = ' +;
'"' + thisform.txtkode.Value + '";'

SQLEXEC(koneksi,msql)
thisform.bersih
thisform.txtkode.SetFocus
thisform.judulgrid
ELSE
thisform.txtkode.SetFocus
thisform.bersih

endif
ELSE
MESSAGEBOX('Data tidak ada')
thisform.txtkode.Value=''
thisform.txtkode.SetFocus
ENDIF
SQLEXEC(koneksi,'select * from anggota','baru')
thisform.judulgrid
endif
-----------------------------------
Object : CMDADD Procedure : Click
----------------------------------
tombol=1
thisform.aktif
thisform.bersih
thisform.txtkode.Value=''
thisform.txtkode.SetFocus
-------------------------------------------
Object : CMDEDIT Procedure : Click
-------------------------------------------
tombol=2
thisform.aktif
thisform.bersih
thisform.txtkode.SetFocus
----------------------------
Object : CMDSAVE Procedure : Click
---------------------------
IF tombol=1
xno=ALLTRIM(thisform.txtkode.Value)
sql="select * from hotel where kode='&xno'"
SQLEXEC(koneksi, sql,'baru')
IF ! EMPTY(baru.kode)
MESSAGEBOX('Data Sudah di pakai')
ELSE
skode=thisform.txtkode.Value
snama=thisform.txtnama.Value
skelas=thisform.cbokelas.value
sbiaya=thisform.txtbiaya.Text
slama=thisform.txtlama.Text
sdiskon=thisform.txtdiskon.Text
stotal=thisform.txttotal.Text
msql ='insert into hotel(kode,nama,kelas,biaya,lama,
diskon,total) values
("'+skode+'","'+snama+'","'+skelas+'","'+sbiaya+'",
"'+slama+'","'+sdiskon+'","'+stotal+'")'
SQLEXEC(koneksi,msql)
THISFORM.Judulgrid
MESSAGEBOX('data sudah tersimpan',1)
ENDIF
thisform.bersih
thisform.pasif
ENDIF

IF tombol=2
skode=thisform.txtkode.Value
snama=thisform.txtnama.Value
skelas=thisform.cbokelas.value
sbiaya=thisform.txtbiaya.Text
slama=thisform.txtlama.Text
sdiskon=thisform.txtdiskon.Text
stotal=thisform.txttotal.Text
msql = 'update hotel set kode="'+skode+'",nama="'+snama+'",
kelas="'+skelas+'",biaya='+sbiaya+',
lama='+slama+',diskon='+sdiskon+',
total='+stotal+' where kode="'+skode+'"'
SQLEXEC(koneksi,msql)
MESSAGEBOX('data sudah tersimpan',1)
thisform.bersih
thisform.pasif
ENDIF
SQLEXEC(koneksi,'select * from hotel','baru')
thisform.judulgrid

----------------------------
Object : CMDDEL Procedure : Click
---------------------------
tombol=4
thisform.aktif
thisform.bersih
thisform.txtkode.SetFocus
-----------------------------
Object : CMDEXIT Procedure : Click
-------------------------
THISFORM.Release
-------------------------

No comments :