OleDBDataAdpter update fails becorse of Fieldname in DB ??

[Sagaert Johan]

The update seems to fail becorse of the fieldname in my DB

One of the fields is called "Zone" in my MDB

If i change the fieldname in both the database and in my test application,
the error is gone....

Any explanation ?

[Pete Davis]

It may be a reserved word. I assume you're using access. To get around this,
in your code, refer to the field as [Zone] instead of Zone. The brackets
indicate that you're referring to a field/table/view or other DB object and
not a reserved word.

Pete

--
http://www.petedavis.net
"Sagaert Johan" <RE*************@hotmail.com> wrote in message
news:%2********************@TK2MSFTNGP10.phx.gbl.. .

The update seems to fail becorse of the fieldname in my DB

One of the fields is called "Zone" in my MDB

If i change the fieldname in both the database and in my test application,
the error is gone....

Any explanation ?

[Sagaert Johan]

This does'nt work , it tries to look for the field [Zone]

eg
oOrderRow["[Zone]"] = "bathroom"; does not work
"Pete Davis" <pd******@hotmail.com> wrote in message
news:ea******************************@news.meganet news.com...

It may be a reserved word. I assume you're using access. To get around this, in your code, refer to the field as [Zone] instead of Zone. The brackets
indicate that you're referring to a field/table/view or other DB object and not a reserved word.

Pete

--
http://www.petedavis.net
"Sagaert Johan" <RE*************@hotmail.com> wrote in message
news:%2********************@TK2MSFTNGP10.phx.gbl.. .

The update seems to fail becorse of the fieldname in my DB

One of the fields is called "Zone" in my MDB

If i change the fieldname in both the database and in my test application, the error is gone....

Any explanation ?

[Pete Davis]

Sorry, my mistake. You don't want the brackets there. You'd want them in the
select statement around the field list (assuming you have a field list). But
in the datarow indexer, you'd simply use oOrderRow["Zone"] = "bathroom";

Pete

--
http://www.petedavis.net
"Sagaert Johan" <RE*************@hotmail.com> wrote in message
news:uQ**************@TK2MSFTNGP09.phx.gbl...

This does'nt work , it tries to look for the field [Zone]

eg
oOrderRow["[Zone]"] = "bathroom"; does not work
"Pete Davis" <pd******@hotmail.com> wrote in message
news:ea******************************@news.meganet news.com...

It may be a reserved word. I assume you're using access. To get around

this,

in your code, refer to the field as [Zone] instead of Zone. The brackets
indicate that you're referring to a field/table/view or other DB object

and

not a reserved word.

Pete

--
http://www.petedavis.net
"Sagaert Johan" <RE*************@hotmail.com> wrote in message
news:%2********************@TK2MSFTNGP10.phx.gbl.. .

The update seems to fail becorse of the fieldname in my DB

One of the fields is called "Zone" in my MDB

If i change the fieldname in both the database and in my test application, the error is gone....

Any explanation ?