Ganti formulanya jadi gini:
{TransSize.tr_codeloc} = {?Lokasi} and
({TransSize.tr_typetransaksi} like 'RFS*' or
{TransSize.tr_typetransaksi} like
'TWS*' or {TransSize.tr_typetransaksi} like 'SFS*' or
{TransSize.tr_typetransaksi} like 'CRSFS*')
[zZzz]
--- In [email protected], Agus Sudana <[EMAIL PROTECTED]> wrote:
>
> berhasil,sy udh perhatikan tanda kurung,
> SELECT *
> FROM TransSize
> WHERE (tr_codeloc='C-FOND') and
> (tr_typetransaksi LIKE 'RFS%' OR
> tr_typetransaksi LIKE 'TWS%' OR
> tr_typetransaksi LIKE 'SFS%' OR
> tr_typetransaksi LIKE 'CRSFS%')
>
> cuma, wktu pake menu edit selection formula di cristal rpt 8.5, sy pake
> parameter lokasi, malah blank. gak ada record mncl sm sekali.
> sy pake script berikut:
> {TransSize.tr_codeloc} = {?Lokasi} and
> {TransSize.tr_typetransaksi} like 'RFS%' or
{TransSize.tr_typetransaksi} like
> 'TWS%' or {TransSize.tr_typetransaksi} like 'SFS%' or
> {TransSize.tr_typetransaksi} like 'CRSFS%'
> ada yg kurang ato slh..? krn sy coba berikan tnda kurung, gak ada efek.
> please help again..
>
> terima kasih
>
> --- Heru Rahadyan <[EMAIL PROTECTED]> wrote:
>
> > Coba di cek,
> > Jangan2 nama field "type" merupakan nama field yg di reserve oleh
VB, jd
> > ngga bs pake J
> > Coba ganti nama fieldnya
> >
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Rony Wijaya
> > Sent: Tuesday, January 30, 2007 6:45 PM
> > To: [email protected]
> > Subject: Re: [Programmer-VB] SQL query like '%'
> >
> > Saya sudah coba dan berhasil, saya coba dengan memakai table lain yg
> > saya punya
> > dengan logika SQL yg sama
> > ex:
> > SELECT * FROM INVENTTABLE
> > WHERE (ITEMID LIKE '003%' OR
> > ITEMID LIKE '004%' OR
> > ITEMID LIKE '005%') AND
> > (DATAAREAID ='C05')
> >
> > Sama kan dengan Logika yg dipakai di Sintax SQL ini :
> > select * from tabel
> > where (type like 'RFS%' or
> > type like 'TWS%' or
> > type like 'SFS%' or
> > type like 'CRSFS%') and
> > (lokasi='C-FOND')"
> >
> >
> >
>
>
>
>
____________________________________________________________________________________
> Do you Yahoo!?
> Everyone is raving about the all-new Yahoo! Mail beta.
> http://new.mail.yahoo.com
>
