I am wrong or not?

Question

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!

Vulpes · 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 Tshimanga · Answer

I would like to say: now its works.

Mfwamba Tshimanga · Answer

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