dataAdapter.Update() sql transactions

[Ana Lindt]

Hi,

When I try to dataAdapter.Update() I always get a "Syntax error in INSERT
INTO statement". If i take a look at the InsertCommand or cmdInsert property
of the dataAdapter, it's just fine:
"INSERT INTO NEMT_REPORTS (PLANT_ID, ACCOUNTABLE, SUBMITED, YEAR,
KPI_ENERGY, KPI_WATER, KPI_WASTEWATER, KPI_GWP, KPI_ENERGYTCOP,
KPI_ENERGYCOST) values (@PLANT_ID, @ACCOUNTABLE, @SUBMITED, @YEAR,
@KPI_ENERGY, @KPI_WATER, @KPI_WASTEWATER, @KPI_GWP, @KPI_ENERGYTCOP,
@KPI_ENERGYCOST)"

So my question is: How can I display the *real* sql command that the
dataAdapter actualy executes against the database?

Thanks for any advice,

Ana L.

 

[William Ryan eMVP]

My guess is that you are using a Reserved word and that escaping [Year] or
chaning it (I know it's an ODBC reserved word and although you aren't using
ODBC client it may be a problem).

however, you can use Sql Profiler and create a trace to see what's being
sent back to the server. This is probably the best way to diagnose it.
HTH

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

 

[William Ryan eMVP]

Ana:

Just as an FYI, here's an article I wrote a while back about Reserved words
http://www.knowdotnet.com/articles/reservedwords.html . I originally
thought this was SqlClient b/c you mention transactions, but I figured I'd
mention it

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

 

[Ana Lindt]

Hi,

I replaced the year column in the database by 'period' and did the same
to my code, i still have the sql insert to syntax error.

The thing is that if I manualy copy paste that query and manualy replace
the @params by their values and execute it against the database, it
works.

I'm going give that sql profiler a try, I hope it works for access mdbs.

regards,

Ana L.

 

[William Ryan eMVP]

Ana:

You may have parameters out of sequence. I forgot this was Access, you
should use ? b/c the positions have to match.

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/