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
<*> 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/
