SQL Syntax error? 2

[apex1x]

Whenever I run this bit of code I get an INSERT INTO syntax error. It might be something really simple but I cant seem to see it at the moment. Any suggestions?

        cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\working\sample.mdb;")
        cn.Open()
        For i = 0 To k - 1
            str = "INSERT INTO prtinvoice (Qty,Desc,Rate,Amount) VALUES('" & tempqty(i) & "','" & tempdesc(i) & "','" & temprate(i) & "','" & tempamount(i) & "')"
            cmd = New OleDbCommand(str, cn)
            cmd.ExecuteNonQuery()
        Next i
        cn.Close()

 

[mansii]

Perhaps you need to ad a space after the VALUES word

 VALUES ('"

Regards,
mansii

 

[apex1x]

tried it... doesn't seem to have an effect. any other suggestions?

 

[mansii]

Well, I could think of 2 possibilities:

1. the [blue]Desc[/blue] field. Perhaps it's a keyword. Try renaming the fieldname.

2. Check these values
tempqty(i)
tempdesc(i)
temprate(i)
tempamount(i)
what are they anyway?

mansii

 

[apex1x]

Haha, you were right on the money! Apparantly "desc" is the SQL command for descending... now it works like a charm
Thanks

 

[mansii]

 

[Swi]

It is a reserved word. If you do not want to rename the field just put brackets around the name.

str = "INSERT INTO prtinvoice (Qty,[Desc],Rate,Amount) VALUES('" & tempqty(i) & "','" & tempdesc(i) & "','" & temprate(i) & "','" & tempamount(i) & "')"

Swi

 

[apex1x]

Thanks for the tip