saya punya table gabung dan parts yang dari acces saya eksport ke sql server 2000 gabung (kode nvarchar 15, nama nvarchar 15, awalq float 8) dan parts(kode nvarchar 15, nama nvarchar 15, awalq float 8)
dan saya coba sedikit fields aja msql = "INSERT INTO GABUNG SELECT KODE,NAMA FROM PARTS" munculnya insert error : column name or number of supplied values does not match table definition. kira2 solusinya gimana ya thank's ----- Original Message ----- From: "Ronald Irawan" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, December 08, 2005 4:41 PM Subject: Re: [indoprog-vb] insert > 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] > > > > > 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 > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
