[RESOLVED] insert command

is there something wrong with the insert sql string in sql ce?
i am using "insert into table (field1) values (value1);" and it tells me that that is an unacceptable command in sqlce. what is the other way to do variables?
it looks something like this

VB Code:

insert into table (field1) values (?)
cecmd.sqlparamets.add("field1", value1)

can i get a little help?

Is this what you mean?

Dim value1 As String = "xxxxx"

INSERT INTO Table (field1) Values ('" & value1 & "')"

no it looks like what i posted. "the function is not recognized by sql server"

VB Code:

Dim cecmd As SqlCeCommand = New SqlCeCommand( _
                "insert into received (jobnum, boxnum, weight, numberrecvd, bay, recdate)" & _
                 " values (" & CInt(lblJobnum.Text) & ", " & CInt(txtBoxnum.Text) & ", " & _
                CDec(txtWeight.Text) & ", " & CInt(txtNReceived.Text) & ", '" & _
                txtBay.Text & "', now());", ceconn)
                cecmd.ExecuteNonQuery()

use getDate() instead of now()
dont think there is any need for the ; at the end, well i never use it anyway.

now is an sql command for datetime which is what i need. anyway i fixed my problem.

getDate() does the same, its sql servers in built function of getting the date & time from the device