Updating a field that contains a ? in its name
- From: "mkean" <mkean@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Jun 2005 13:19:03 -0700
I am trying to update an Access database using an OleDb adapter in visual
studio .Net 2003. One of the fields that I have t update contains a question
mark in the name - the name is Active?. If I do not add any parameters to my
UPDATE command I get an error stating that no data was supplied for a
required parameter. I assume that the ? in the field name is being seen as a
parameter placeholder. I have tried a number of methods to have the ? be
accepted as part of the column name but have not been successful. How can I
write an OleDb command to do this.
.
- Follow-Ups:
- Re: Updating a field that contains a ? in its name
- From: Erland Sommarskog
- Re: Updating a field that contains a ? in its name
- Prev by Date: Deploy MSDE 2000 database
- Next by Date: Re: Updating a field that contains a ? in its name
- Previous by thread: Deploy MSDE 2000 database
- Next by thread: Re: Updating a field that contains a ? in its name
- Index(es):