"SAL" <SAL_@NoNo.com> wrote in message
news:uwddhTudHHA.4772@TK2MSFTNGP05.phx.gbl...
> 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
>
>

"William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
news:uVB5BXudHHA.2268@TK2MSFTNGP02.phx.gbl...
> Try using the "%" wildcard.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "SAL" <SAL_@NoNo.com> wrote in message
> news:uwddhTudHHA.4772@TK2MSFTNGP05.phx.gbl...
>> 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
>>
>>
>
>