kalu pake sql server jalan kok. asal allow null nya jangan di centang dan diisi default valuenya ''
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Noe Sent: Wednesday, February 13, 2008 11:39 AM To: [email protected] Subject: [Programmer-VB] Re: FIELD KOSONG biasanya klo pake ' ' jarang jalan. mending langsung is null aja... --- In [email protected], "Rizky Prihanto" <[EMAIL PROTECTED]> wrote: > > SELECT * FROM data WHERE trim(nobukti)='' OR nobukti IS NULL > > > -- > regards, > > Rizky Prihanto > ¢¾ http://www.software-arsitek.web.id ¢¾ > > 2008/2/13 arief nurhadi <[EMAIL PROTECTED]>: > > > Rekan vb ada yang bisa bantu > > > > pada table ada 2 field yaitu "nobukti" dan "nama" > > pada field "nama" saya input data, tp "nobukti" kosong > > > > ada yang tau gimana menampilkan ke datagrid data tersebut jika > > "nobukti"nya kosong > > > > saya pakai sintax: > > > > DT.open("select * from data where nobukti=' ' "),CN > > > > tp data tidak tampil. > > ada yang bisa bantu scripnya.... > > > > tq > > > > > > > Wahana Programmer Groups Links Yahoo! Groups Links No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.2/1273 - Release Date: 2/12/2008 9:31 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.2/1273 - Release Date: 2/12/2008 9:31 AM
