Arsip: Cara Membuat Tabel yang Data master tidak bisa dihapus

more 13 years ago
onsir
Bagaimana cara membuat data tabel master tidak bisa dihapus klw data itu sudah ada transaksinya (integriy constartin klw gak salah)
misal saya akan membuat tabel dari delphi dengan perintah
create table if not exists masterbarang('KodeBarang varchar(5) default '','namabarang varchar(20) default ''', primary key kodebarang(kodebarang))engine=innodb);
create table if not exists transaksi('kodebarang varchar(5) default null,Qty int(3) default '0' ) engine=innodb;
atas bantuannya saya ucapkan terima kasih

more 13 years ago
reminder2k1
ada applikasi namanya navicat, applikasi itu bisa mengatur relasi antar table...

more 13 years ago
reminder2k1
REATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[table_options] [select_statement]
create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
or PRIMARY KEY (index_col_name,...)
or KEY [index_name] (index_col_name,...)
or INDEX [index_name] (index_col_name,...)
or UNIQUE [INDEX] [index_name] (index_col_name,...)
or [CONSTRAINT symbol] FOREIGN KEY index_name (index_col_name,...)
[reference_definition]
or CHECK (expr)
coba pelajari sintax FOREIGN KEY

more 13 years ago
onsir
ya, dah ketemu. terima kasih
taktifitaslog CREATE TABLE taktifitaslog (
KodePemakai varchar(10) default NULL,
TipeAksi varchar(15) default NULL,
TglAksi datetime NOT NULL default '0000-00-00 00:00:00',
KodeDok1 varchar(100) default NULL,
Catatan varchar(500) default NULL,
NomorInc int(12) NOT NULL auto_increment,
Proses varchar(500) default NULL,
NamaProgram varchar(100) default NULL,
NamaKomputer varchar(20) default NULL,
UNIQUE KEY NomorInc (NomorInc),
KEY FK_taktifitaslog (KodePemakai),
CONSTRAINT FK_taktifitaslog FOREIGN KEY (KodePemakai) REFERENCES tpemakai (KodePemakai) ON DELETE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- Error Mysql " request returned with SQL_ERROR"
by hak3nd3n in MySQL more 11 years ago - vcl Barcode
by strike_set in Tutorial & Community Project more 13 years ago - Firebird alias record
by vera in FireBird more 12 years ago - ada yg bisa query ini??
by R-One in MySQL more 13 years ago - buat cd interaktif atau pembelajaran pake delphi
by kepew in Hal umum tentang Pascal Indonesia more 10 years ago - Minta Masukan Dari Para Ahli ^^(Buat Laporan)....
by juan81 in Hal umum tentang Pascal Indonesia more 12 years ago - Ada yang punya tutorial XML g nih ?
by EkoIndri in Tutorial & Community Project more 15 years ago - Kirim SMS lebih dari 1
by rusteten in Tip n Trik Pemrograman more 13 years ago - Membuat Text "MARQUEE"
by i_hasibuan in Form Enhancement & Graphical Controls more 13 years ago - Link Download ::
by Tbawor in Tip n Trik Pemrograman more 12 years ago