baik agan2 kali ini ane mw coba share gmn ngbuat 1 form menggunakan vb 6,disini form yang akan
kita buat adalah form entry data buku untuk program perpustakaan
Saturday 3 March 2012
Monday 27 February 2012
07:01
1 comment
create table kamar(tipekamar text (10) not null primary key,nmkamar text (15),harga currency);
insert into kamar values("deluxe","anggrek","120000");
insert into kamar values("vip","melati","100000");
create table karyawan(nok text(4) not null primary key,nama text (10) ,alamat text (15),shift text (5));
insert into karyawan values("101","asep","bogor","pagi");
insert into karyawan values("102","udin","bandung","malam");
create table billroom(billnumber text (10) ,tanggal date,tipekamar text (10),nok text (4),bnykkamar number);
insert into billroom values("ab01","09/04/2011","deluxe","101","1");
insert into billroom values("ab02","10/04/2011","vip","102","1");
2 table
SELECT billroom.billnumber, billroom.tanggal, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar;
3 table
SELECT billroom.billnumber, billroom.tanggal, karyawan.nama, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM (kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar) INNER JOIN karyawan ON karyawan.nok=billroom.nok;
insert into kamar values("deluxe","anggrek","120000");
insert into kamar values("vip","melati","100000");
create table karyawan(nok text(4) not null primary key,nama text (10) ,alamat text (15),shift text (5));
insert into karyawan values("101","asep","bogor","pagi");
insert into karyawan values("102","udin","bandung","malam");
create table billroom(billnumber text (10) ,tanggal date,tipekamar text (10),nok text (4),bnykkamar number);
insert into billroom values("ab01","09/04/2011","deluxe","101","1");
insert into billroom values("ab02","10/04/2011","vip","102","1");
2 table
SELECT billroom.billnumber, billroom.tanggal, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar;
3 table
SELECT billroom.billnumber, billroom.tanggal, karyawan.nama, billroom.tipekamar, billroom.nok, billroom.bnykkamar, kamar.tipekamar, kamar.nmkamar, kamar.harga, [bnykkamar]*[harga] AS subtotal, IIf([bnykkamar]>2,[subtotal]*10/100,0) AS diskon, [subtotal]-[diskon] AS total
FROM (kamar INNER JOIN billroom ON kamar.tipekamar=billroom.tipekamar) INNER JOIN karyawan ON karyawan.nok=billroom.nok;
Saturday 25 February 2012
22:40
No comments
Mungkin pengguna BB udah banyak banget yah,tp ane yakin ga semuanya dah pada tau shortcut di BB,nah disini ane cuma mau share list shortcut keypad di BB.Tapi sebelum kita menggunakan shortcut yang ada di BlackBerry, kita harus mematikan fungsi Dial From Home Screen terlebih dahulu. Jika kita tidak mematikan otomatis ga kan berfungsi,nah untuk cara ngaktifinnya: Option-Phone Option-General Option-Dial From Home Screen (No)-back-save
Saturday 18 February 2012
Saturday 21 January 2012
Sunday 30 October 2011
Monday 17 October 2011
Sunday 28 August 2011
Subscribe to:
Posts (Atom)
