dear pbers, sorry kalo cuma sy yg aktif bertanya :-))
dibawah ini ada script sql yg sy letakkan di window utk meng update tabel, kalo sy jalankan di query analyser nya sql server 2000, maka akan ada hasilnya tapi stlah sy embedd ke powerbuilder, hasilnya tdk ada alias tidak ada data yg dihasilkan dari perintah sql ini. padahal tdk ada error yg ditunjukkan. berikut perintahnya (ini utk mengupdate yg diambil dari 2 tabel) : UPDATE acc3 SET acc3.tgl_transaksi = x.tgljurnal,acc3.harga_jual = x.hrgjual,acc3.harga_beli = x.hrgbeli FROM acc3, (SELECT MAX(b.tgljurnal) tgljurnal, a.kode3, sum(b.hrgjual) hrgjual, sum(b.hrgbeli) hrgbeli FROM master a, detil b WHERE a.nobukti = b.nobukti AND b.tgljurnal >= '1/1/2006' AND b.tgljurnal <= '1/31/2006' GROUP BY a.kode3) x WHERE acc3.kode3 = x.kode3 ; script ini sudah di test di sqlserver 2000 jalan. mohon koreksinya, apakah ada perintah yg harus ditambahkan sblm script diatas? krn yg sy tau bahwa powerbuilder itu "embedd sql" jadi menurut sy pb akan langsung menjalankan nya tanpa harus memanggil objek koneksi spt yg "selama ini sy buat" thanks atas tanggapanya. salam ruthdie __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ----------------------------------------------- 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/
