Tambahan :
string ls_sql, ls_nip="1005 , 1006"
ls_sql = "delete from master_employee where nip in("+ls_nip+");"
EXECUTE IMMEDIATE :ls_sql USING SQLCA;
// Tested on ASA 8
----- Original Message -----
From: "Ahmad Khaironi" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Saturday, December 22, 2007 10:56 AM
Subject: Re: [indopb] embeded sql
> pk operator "LIKE"
> contoh:
> 1. DELETE FROM master_employee WHERE nip LIKE "1005%" OR nip LIKE "1006%"
> (menghapus data yang berawalan 1005 dan 1006)
>
> 2. DELETE FROM master_employee WHERE nip LIKE "%1005" OR nip LIKE "%1006"
> (menghapus data yang berakhiran 1005 dan 1006)
>
> 3. DELETE FROM master_employee WHERE nip LIKE "%1005%" OR nip LIKE "%1006%"
> (menghapus data yang mengandung 1005 dan 1006)
>
> harry hartono <[EMAIL PROTECTED]> wrote:
> temen2,
> mohon bantuan. saya mau delete data yang nip nya mengandung 1005 dan 1006 di
> table master_employee
> contonya :
>
> ls nip="1005 , 1006"
> delete from master_employee
> where nip in(:ls_nip);
>
>
> tapi kok hasilnya data yang ada di master_employee terhapus semua
>
> solusinya bagaimana ya?
-----------------------------------------------
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/
