UPDATE missing required parameter

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Hi there,

I'm using ADO.NET to update a table in an access database. The table
contains the following columns,

id = auto number
filename = Text
checkdate = Date/Time
data = OLE Object

I'm adding to the database and using SELECT commands successfully so no
problems there. No columns are "required" as such and what I am trying to
do is simply update 2 columns in a row with a particular ID.

My UPDATE command looks like,

"UPDATE thumbnails SET datelastmodified=@datelastmodified, data=@data
WHERE thumbnailid=@thumbnailid"

I'm adding the correct data into each parameter via the command objects
parameters.add method and all *should* be okay. But I'm being told that,

"System.Data.OleDb.OleDbException: No given for one or more required
parameters"

Am I missing something? Thanks in advance.

Nick.
 
Woops, please change that to
id = auto number
filename = Text
checkdate = Date/Time
data = OLE Object
Click to expand...
"UPDATE thumbnails SET checkdate=@checkdate, data=@data WHERE id=@id"
Click to expand...

I changed the names just to make it simpler for my message...
 
Back
Top