mas vbpian and utk smuanya jg, yg telah bantu,Thank u very much for the help..
regards,
-agus-
--- vbpian <[EMAIL PROTECTED]> wrote:
> 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
> >
>
>
>
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited
