Field angka1 dan angka2 type data numeric, saya sudah coba hilangkan tanda petik tetapi error juga, apa karena fungsi replace ya ?,
----- Original Message ----- From: "madhi" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, July 27, 2005 11:22 AM Subject: Re: [Programmer-VB] SQL statement tidak jalan di SQL Server > field angka1 dan angka2 type datanya apa? > klo numeric, tidak perlu di apit petik tunggal. > klo bisa, tanggalnya di beri format mm/dd/yyyy. > > Mainform.cnCoba.Execute "insert into angka (angka1,angka2,tanggal) values > (" & Val(Trim(Replace(Text2.Text, ",", "."))) & "," & > Val(Trim(Replace(Text3.Text, ",", "."))) & ",'" & > format(DTPicker1.Value,"mm/dd/yyyy") & "') " > > > ----- Original Message ----- > From: "Udin" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, July 27, 2005 11:08 AM > Subject: [Programmer-VB] SQL statement tidak jalan di SQL Server > > >> Dengan hormat, >> Ada yang tahu ya, kenapa kode berikut error waktu databasenya saya ganti >> dengan SQL Server, tetapi waktu saya pakai access tidak ada masalah. >> Kodenya >> saya tulis dalam satu baris panjang >> >> Mainform.cnCoba.Execute "insert into angka (angka1,angka2,tanggal) values >> ('" & Val(Trim(Replace(Text2.Text, ",", "."))) & "','" & >> Val(Trim(Replace(Text3.Text, ",", "."))) & "','" & DTPicker1.Value & "') >> " >> >> Mohon bantuannya >> >> Terima kasih >> Syafruddin >> >> >> >> Untuk keluar dari millis ini, kirim email kosong ke: >> [EMAIL PROTECTED] >> >> >> Yahoo! Groups Links >> >> >> >> >> >> >> > > > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > Yahoo! Groups Links > > > > > > > Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-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/
