Trim's Mas Nando atas pencerahannya...

----- Original Message ----- 
From: "Nando Gurning" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, May 11, 2006 11:38 AM
Subject: Re: [indopb] tanya


> kl menurut saya lebih baik anda menggunakan event 
> itemchange kl menggunakan dropdowndatawindow
> 
> contoh kasus
> ---------------
> db : MSSQL 2000
> PB ver 8.0
> buat tabel contoh :proses
> ---------------------
> if exists (select * from dbo.sysobjects where id = 
> object_id(N'[dbo].[proses]') and OBJECTPROPERTY(id, 
> N'IsUserTable') = 1)
> drop table [dbo].[proses]
> GO
> 
> CREATE TABLE [dbo].[proses] (
> [kd_proses] [varchar] (5) COLLATE 
> SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [nama] [varchar] (30) COLLATE 
> SQL_Latin1_General_CP1_CI_AS NULL
> ) ON [PRIMARY]
> GO
> 
> dan isi data dummy/contoh:
> kd_proses | nama
> 01A    PROSES SATU
> 02B    PROSES DUA
> 03B    PROSES LAINNYA
> 
> LALU BUAT dddw_proses(tabular)
> 
> dan  buat form dw_proses
> 
> proses: [DropDownDataWindow]-dddw_proses
> nama: [field nama]
> 
> lalu pada event itemchanged copikan script ini:
> 
> string ls_nm
> 
> if dwo.name = 'kd_proses' then
> select nama into :ls_nm
> from proses
> where kd_proses=:data
> using sqlca;
> this.setitem(row,'nama',ls_nm)
> end if
> 
> 
> 
> semoga bisa membantu
> 


------------------------ Yahoo! Groups Sponsor --------------------~--> 
You can search right from your browser? It's easy and it's free.  See how.
http://us.click.yahoo.com/_7bhrC/NGxNAA/yQLSAA/NhFolB/TM
--------------------------------------------------------------------~-> 

-----------------------------------------------
IndoPB - Indonesia PB User Group 
Learn PB6 by download FasTrack to PB6 at :
http://groups.yahoo.com/group/indopb/files/Belajarpb6/ 
To Unsubscribe,send a blank message to: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indopb/

<*> 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/
 


Kirim email ke