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
