mdb / dot net 1.0 / can't delete for some reason

[Filip Wtterwulghe]

Hello,

I try to delete a record from a MDB file , but I get this strange error
"Syntax error (missing operator) in query expression 'nicexport where admno
= 43469' . Insert / Select works without a problem . It's only this delete
that raises a problem . Strange is that the error message , does not show
the delete statement .

Does anybody have an idea ?

Dim oCom As New OleDb.OleDbCommand()

Try

oCom.Connection = pConnection

oCom.CommandText = "delete nicexport where admno = " & nPAdmNr

oCom.ExecuteNonQuery()

Catch exc As Exception

Call ShowError(UC_ERR_SOURCE, "AdmDelete")

End Try

oCom = Nothing



Filip W.

 

[Filip Wtterwulghe]

Hello,

I found it ... forgot the FROM in the SQL statement...