Victor

Victor

  • NA
  • 25
  • 0

How to update table field with a keyword as name??

Apr 15 2009 9:18 AM

Hi,

I have a table ("TableVisits") with some fields (columns), and the name of one of them is "Desc" (=Description).

When I try to update the table

oDataAdapter.Update(oDataSet, "TableVisits");

I get the following exception:

"Syntax error in UPDATE statement."

It seems the Adapter refuses to work with table fields which have a language keyword as name.

However, I cannot change the database tables' field names.

So I was wondering if there is a way to get around this annoying problem.

Any help would be very much appreciated.

Thanks in advance.

Victor


Answers (6)