a_date yg dikirim datanya ada, dan jika ditampilkan di dw nilainya muncul.
tp di dlm functionnya nilainya menjadi null... ???? --- In [email protected], "Telagas" <[EMAIL PROTECTED]> wrote: > > Coba dicek a_date yang dikirim ke function tersebut ada datanya gak. > Tampilkan saja a_date (kolomn yang menjadi nilai parameter untuk function > tsb) tersebut di dwnya. > > -ts- > > ----- Original Message ----- > From: "yazid" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Thursday, November 24, 2005 10:04 AM > Subject: [indopb] PB with SQL Server -- date on DW > > > > Guys > > > > PB with SQL Server, saya buat DW, lalu saya beri ComputeObject. > > ComputeObject ini memanggil function yg sintaxnya sbb: > > > > Function ini utk mengambil rate dari mata uang asing. > > > > ------------------------------------- > > .... > > .... > > SELECT xcgrate.xcg_value > > INTO :ld_rate_value > > FROM xcgrate > > WHERE ( xcgrate.xcg_currency = :a_curr ) AND > > ( xcgrate.xcg_date = :a_date ) ; > > .... > > .... > > ------------------------------------- > > > > Tetapi :a_date yg diterima di function nilainya NULL (terlihat ketika > > saya debug), padahal a_date yg diberikan dari DW adalah format > > tanggal. > > > > ?????? > > > > Apakah yg harus diperhatikan pd DW yg menggunakan db SQL Server > > terutama pd tipe data DATETIME nya? > > > > Thanks > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] 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/
