Loh.. insert itu sama saja...kemungkinan besar kenapa gak bisa adalah lebar data < dari data yg akan anda insert... coba di cek lagi ....
Salam Ronald Irawan Pt. Sanghiang Perkasa Gd. Graha Kirana Lt.5 Jl Yos Sudarso Kav.88 Jakarta "garudamas" <[EMAIL PROTECTED]> Sent by: [email protected] 08/12/2005 04:24 PM Please respond to [email protected] To <[email protected]> cc Subject [indoprog-vb] insert mungkin ada yang bisa bantu kalau connec pakai acces saya selalu pakai di bawah ini tapi pindah ke sql server muncul binary data be truncated. kalau nggak pakai insert bisa tampil data. kira2 cara pakai insert di sql server gimana ya. msql = "insert into gabung select parts.kode, parts.Nama, parts.cat, parts.jenis, parts.awalq, parts.awalh, " & _ " (select sum(qty) from kredit where tglkredit>='" & Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkredit<='" & Format(dpSp.Value, "MM/DD/yyyy") & "' group by kredit.kode having(kredit.kode=parts.kode)) as krQty, " & _ " (select sum(qty*harga) from kredit where tglkredit>='" & Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkredit<='" & Format(dpSp.Value, "MM/DD/yyyy") & "' group by kredit.kode having(kredit.kode=parts.kode)) as krHarga, " & _ " (select sum(qty) from masuk where tglmasuk>='" & Format(dpDr.Value, "MM/DD/YYYY") & "' and tglmasuk<='" & Format(dpSp.Value, "MM/DD/yyyy") & "' group by masuk.kode having(masuk.kode=parts.kode)) as mQty, " & _ " (select sum(qty*harga) from masuk where tglmasuk>='" & Format(dpDr.Value, "MM/DD/YYYY") & "' and tglmasuk<='" & Format(dpSp.Value, "MM/DD/yyyy") & "' group by masuk.kode having(masuk.kode=parts.kode)) as mharga, " & _ " (select sum(qty) from keluar where tglkeluar>='" & Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkeluar<='" & Format(dpSp.Value, "MM/DD/yyyy") & "' group by keluar.kode having(keluar.kode=parts.kode)) as kQty, " & _ " (select sum(qty*harga) from keluar where tglkeluar>='" & Format(dpDr.Value, "MM/DD/YYYY") & "' and tglkeluar<='" & Format(dpSp.Value, "MM/DD/yyyy") & "' group by keluar.kode having(keluar.kode=parts.kode)) as kharga " & _ " from parts order by parts.kode" thank's Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Ikuti juga forum diskusi VB.net dengan mengirim email kosong ke [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> 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/
