[RESOLVED] insert command

[citizenstitch]

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

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

can i get a little help?

[Strider]

Is this what you mean?

Dim value1 As String = "xxxxx"

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

[citizenstitch]

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

[citizenstitch]

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()

[Strider]

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

[citizenstitch]

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

[Strider]

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