> 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..
>
>
Udah coba pake cara manipulasi dari Data Window?
Kalo caranya lewat data window gini caranya:
Pada Tab Where pilih nama kolom yang akan dijadikan
kata kuncinya dengan Operatornya LIKE.
Buat sebuah RETRIEVAL ARGUMENT melalui menu Design.
Name | Type
sa String
Buatkan SinggelLineEdit(Sle_1)& ControlButton(Cb_1)
Buatkan Juga sebuah Varuabel,type String VG_NAMA
Scriptnya :
Event Clicked Cb_1:
VG_NAMA = sle_1.text
STRING vkata,vsa
vsa = vg_kata
IF (len(vsa)) < 1 OR isnull(vsa) = TRUE OR vsa = ''
THEN vsa = '%'
vkata = '%'+ vsa +'%'
dw_1.retrieve(vkata)
Okey.....
silahkan mencoba......semoga saya g salah pengertian
dengan pertanyaannya....
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
-----------------------------------------------
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/
