S
SAL
Hello,
Using the designer in my project, I created a DataTable for one of the
tables in an Access database. I created a TableAdapter for that DataTable by
adding queries. For the most part, the queries are executing correctly but
this one does not return any rows. If I past the sql into the Access
database from the TableAdapter, it returns rows. Does anyone know how to
debug what the command is sending to the Access database for any particular
query?
This query uses parameters and I'm afraid it's not sending the where clause
correctly..
For instance, using the query builder in VS 2005, my select statement
returns all the rows of data.
However, as soon as I put in this where clause:
WHERE (ReportedWeeds.Source LIKE '*' + ? + '*')
No records are returned. Yet, if I execute the query within MS Access using
the same WHERE clause, it returns two records.
Any help with this would be much appreciated
S
Using the designer in my project, I created a DataTable for one of the
tables in an Access database. I created a TableAdapter for that DataTable by
adding queries. For the most part, the queries are executing correctly but
this one does not return any rows. If I past the sql into the Access
database from the TableAdapter, it returns rows. Does anyone know how to
debug what the command is sending to the Access database for any particular
query?
This query uses parameters and I'm afraid it's not sending the where clause
correctly..
For instance, using the query builder in VS 2005, my select statement
returns all the rows of data.
However, as soon as I put in this where clause:
WHERE (ReportedWeeds.Source LIKE '*' + ? + '*')
No records are returned. Yet, if I execute the query within MS Access using
the same WHERE clause, it returns two records.
Any help with this would be much appreciated
S
