Hi,

I try to configure a TableAdapter GetData( ) method.

I have the following code

 SELECT [ΑΡ_ΠΑΡΟΧΗΣ], [ΗΜΕΡ_ΑΙΤΗΣΗΣ], [ΗΜΕΡ_ΕΚΤΕΛ_ΜΕΛΕΤΗΣ], [ΗΜΕΡ_ΕΚΤΕΛΕΣΗΣ], [ΗΜΕΡ_ΣΥΝΔΕΣΗΣ], [Α_Α]

FROM [ΠΑΡΟΧΕΣ_ΔΕΣ] WHERE ([ΑΡ_ΠΑΡΟΧΗΣ] = @ΑΡ_ΠΑΡΟΧΗΣ)

I take the following error message;

Error in Where clause near '@'

Unable to parse query text

Any help? 

I suggest that you amend the spelling of parameter as the following was parsed without error.

DECLARE  @ΑΡ_PΑΡΟΧΗZ VARCHAR(50)
SELECT [ΑΡ_ΠΑΡΟΧΗΣ], [ΗΜΕΡ_ΑΙΤΗΣΗΣ], [ΗΜΕΡ_ΕΚΤΕΛ_ΜΕΛΕΤΗΣ],
[ΗΜΕΡ_ΕΚΤΕΛΕΣΗΣ], [ΗΜΕΡ_ΣΥΝΔΕΣΗΣ], [Α_Α]
FROM [ΠΑΡΟΧΕΣ_ΔΕΣ] WHERE ([ΑΡ_ΠΑΡΟΧΗΣ] = @ΑΡ_PΑΡΟΧΗZ) 

 Thanx in advace for your answer.

 I have allready tried with declare and I had an 'error to parse query.'

I use a ODBC  to connect with SQL server 2000.

I had allready tried  the previous code  with SQL express edition locally and it works fine!

Same happen with me also

i m trying to connect MS-access

using TableAdapter Configuration Wizard but at Wizard result it shows same error but it works in QueryBuilder window

any body have any idea?

Thanks in advance

Ulhas

I have the same problem. I want to configure a TableAdapter GetProductsByCategoryID(@CategoryID) method.

I tried the following:

SELECT *
FROM Products
WHERE CategoryID = @CategoryID

It keeps returning:

Error in Where clause near '@'

Unable to parse query text

I'm using a MySQL ODBC 5.1 driver.

Can anyone help? I've been stuck for hours on this one..

Where your SQL script resides? In Stored Procedure or as a string in your code?

Bazanaka:

I'm using a MySQL ODBC 5.1 driver.

As your back-end database is not SQL Server, I suggest that you ask your question on a new thread.

I created a new thread for my question here