I am wrong or not?

Mfwamba Tshimanga

Hi!

In my reportviewer process everything running fine. But when I put this lines of queries in my dataSet1.xsd file to filter the data I need its gives me an error. Very strange when I use a sql database its works. But right now I am using a Ms access data base and its doesnt work. Its gives this error: Error in WHERE clause near '@'
Unable to parse query text.

My line of queries:

SELECT Id, name FROM cars

where name = @x

I need a big help. I passed the last night without sleeping to thing about it. But no result!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
Accepted answer
Generally, with MS Access, parameters are identified by position rather than by name.

A question mark is used to indicate each parameter.

So I'd try changing your query (but not the parameter creation code) to:

SELECT Id, name FROM cars
where name = ?
Mfwamba Tshimanga11y ago
I would like to say: now its works.
Mfwamba Tshimanga11y ago
@Vulpes

Many, many, many thanx. I do suffer a lot to resolv this problem. Not its works.
I can rest a little bit.