Exception in a Query

Question

can anyone tell me why this query throws an error "No value given for one or more required parameters."

Select Status from [Viewer$] WHERE SlNo-Viewer < 4 ... I'm trying to query an excel file and this query is not working with that....Please help....

Are you sure the problem is with the query, not how you are performing the query? i.e. the C# code around it — RichardTheKiwi
– RichardTheKiwi, Commented Mar 24, 2011 at 7:49
Yes i think...because the query is working fine when i'm searching for a text. — NewBie
– NewBie, Commented Mar 24, 2011 at 7:57
So why did you tag it C#? Please remove the tag if it's not relevant to the problem. — user447356
– user447356, Commented Mar 24, 2011 at 8:17
I'm using the query with C# code that's why i tagged it with C# — NewBie
– NewBie, Commented Mar 24, 2011 at 8:21

user447356 · Accepted Answer · 2011-03-24 08:16:02Z

2

If SlNo-Viewer is name of a single field, the minus character in the field name is interpreted as the minus operator and it's trying to subtract field called Viewer from field called Slno.

Try this instead:

Select [Status] from [Viewer$] WHERE [SlNo-Viewer] < 4

answered Mar 24, 2011 at 8:16

user447356

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exception in a Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related