kalau saya mengenai format tgl PB dan MSSQL 2000; setiap retrival dari MSSQL2000 saya convert sql statement select nya jadi; convert(varchar(20), <namafieldtanggal>, 1) //mm/dd/yy
kalau di PB nya dimasukkan ke editmask control, update nya ke MSSQL2000 cukup pakai string saja; contoh '12/27/04' atau '12/27/2004' dan ga ada masalah tuh.. oke2 aja.. notes: contoh di atas hanya untuk sql embeded.. kalau update dari dw, saya harus lihat2 lagi aplikasi saya, lupa soalnya.. tapi seingat saya, format tanggal dari dan ke PB, dari MSSQL2000 selalu disamakan formatnya 'mm/dd/yyyy' -- http://rikyandrian.blogspot.com <http://rikyandrian.blogspot.com/> riky andrian /*no better future than the processors...*/ ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> 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/
