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/
