Salam, Kalau nggak salah, contoh dari malx udah bener, cuma ketika di coba rio, kata "and" di rubah jadi "or" dalam querynya sehingga hasilnya berubaha logic, coba deh diganti jadi "and", hasilnya bagaimana.
Best Regards. --- In [email protected], "Rio Albert" <[EMAIL PROTECTED]> wrote: > > Udah dicoba tapi blom bisa2 nih. > > > > Contoh nya gini . > > > > Data : 1234a, 3b, 1234567c > > > > saya hanya mau ambil data yang 1234567c aja.. > > pake NOT LIKE '%a' or NOT LIKE '%b' masih muncul 3 3 nya.. > > > > > > > > _____ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > malx 97 > Sent: Wednesday, February 06, 2008 3:03 PM > To: [email protected] > Subject: Re: [indopb] tanya dong > > > > > Coba Where [filedname] not like '%a%' and [filedname] not like '%b%' > > > > -------Original Message------- > > > > From: Rio Albert <mailto:[EMAIL PROTECTED]> > > Date: 05/02/2008 22:54:25 > > To: [EMAIL PROTECTED] <mailto:[email protected]> com > > Subject: [indopb] tanya dong > > > > PB'rs.. > > Kalo pemakaian where clause EXISTSatau NOT EXISTS gmn ya ? > > > > Contoh kasus : saya mau query data yang mana where caulse nya tdk terdapat > huruf 'a' dan huruf 'b' > > Mohon pencerahannya ..TQ > > > > Rio Albert > > > > > > > > > > > > > > > > > > _____ > > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try > <http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62sR8H > DtDypao8Wcj9tAcJ%20> it now. > ----------------------------------------------- IndoPB - Indonesia PB User Group An Indonesian PowerBuilder User Group's Event 2nd PowerBuilder Update Rumah Sakit Jantung Harapan Kita 26/27 August 2006 To Register : http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indopb/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
