Artinya dari ke 2 field tsb harus selalu unik khan. Kalau pakai UNIQUE di keduanya gimana ? ----- Original Message ----- From: Budi To: [EMAIL PROTECTED] Sent: Sunday, August 31, 2003 6:17 AM Subject: [Delphindo] Validasi data sblm posting
Saya punya sbh tabel yg isinya 2 buah field: [Kode] dan [Nama]. Syaratnya, *tidak boleh* ada [Kode] yg sama walaupun dg [Nama] yg berbeda, *dan* juga *tidak boleh* ada [Nama] yg sama walaupun dg [Kode] yg berbeda. Jadi misalnya ada "001 Mouse" dan "001 Keyboard" tidak boleh. "001 Mouse" dan "002 Mouse" jg tidak boleh. Pd pemrograman multi-user, gimana sebaiknya cara posting datanya. Misalnya begini: 1. Cek apakah ada data kembar ([Kode] ataupun [Nama])? 2. Jika tidak ada, post. Tapi jika langkah 1 selesai dilakukan, ternyata ada user lain yg post (dg data kembar), maka langkah 2 akan menghasilkan error. Apakah dengan cara lock pd row-level? Tapi apakah semua database server mendukung locking pd row-level? Adakah cara yg lebih baik (efisien) ? ===== Thx __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com Yahoo! Groups Sponsor ADVERTISEMENT Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511 http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/i7folB/TM ---------------------------------------------------------------------~-> Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
