Dear All,

Saya bener2 Newbie, mohon dibantu masalah berikut :
-----
Private Sub cmdSave_Click()
Dim msql As String

If txtMatId.Text <> "" Then
        cnn.BeginTrans
        If txtMatId.Enabled = True Then         
            msql = "Insert Into
Material(MAT_ID,MAT_NAME,UOM,PRICE,CURRENCY,SUPLIER_ID,DATE_INPUT)" & _
                " Values('" & txtMatId.Text & "','" & txtMatName.Text
& "', " & _
                " '" & cmbUom.Text & "'," & Val(txtPrice.Text) & "," & _
                " '" & cmbCur.Text & "','" & txtSplId.Text & "'," &
dtpIndateMatmas.Value & ")"
                
            cnn.Execute (msql)
-----

Kenapa perintah insert into ini ngga mau jalan, errornya : [ODBC
Microsoft Driver] Syntax Error in INSERT INTO Statement.

Terima kasih sebelumnya.







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/
 


Kirim email ke