Actual command sent to access

  • Thread starter Thread starter Ben de Vette
  • Start date Start date
B

Ben de Vette

Hi,

is it possible to see the actual SQL command which is sent to Acces when
using an OleDbDataAdapter?
Al I can see now is that an update command failed.
Why, is not told.

Thanks in advance,
Ben
 
Ben said:
is it possible to see the actual SQL command which is sent to Acces
when using an OleDbDataAdapter?
Al I can see now is that an update command failed.
Why, is not told.
Click to expand...

Ben,
Open the DataAdapter's UpdateCommand property, then drill down
on the SQL Update command that being used.

Note if you were using MSDE or SQL Server, you could use the
SQL Server Profile tool to see the actual command being sent.
But with Access, you are limited...
 
Carl,

I already found this command string, but it is filled with the question mark
sign which still has to be filled with the parameters. I am looking for the
way to see the actual command sent.

Anyone?
Ben
 
Yep. Anytime you use (and i advise you do not) but any time you do you
usually have to encase it in Brackets. [Fieldname] Although if one can avoid
reserved words one should.
 
Back
Top