Is this a bug? The Where Clause behaves differently in the Fill Dataset and the Select Command

  • Thread starter msnews.microsoft.com
  • Start date
M

msnews.microsoft.com

Hi All,

When I use a SQL Query to Fill the Dataset if I use the following Where
Clause

( [AUG] > '100' )

Then I am getting a 'Data Type Mismatch Error' because the Field Type is
double.

At the same time if I use the same Where Clause in the Select() command as
the Filter Expression then I am getting the results without any problem.

Is this a bug?

Thanks

Anand Ganesh
 
M

Mohamoss

Hi Anand
try while removing the quotes ( [AUG] > 100 )
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Do I change the where clause of the TableAdapter 2
LINQ to SQL ad hoc filter with where clause 6
Is Lambda (=>) the Linq equivalent of a When/Where clause? 3
Where Clause with the OpenReport command 1
Error in my WHERE clause - please help 3
DateDiff function throwing error in Where clause 7
A complex SELECT in two phases 6
Is this a Bug ? Image and NumericControl 2

Top