Parameter object is improperly defined. Access vs MSSQL

Hi, I have big problem with ADO parameters.

I have tried to execute query using ADOQuery with parameters.

SELECT NULL AS Extended, Count(*) AS IntValue, NULL AS AValue
FROM Answers AS A
WHERE (A.SurveyID= :SurveyID ) AND (A.QuestionID = :QuestionID ) AND
(A.Extended <> 0)
UNION ALL
SELECT A.Extended, F.IntValue, F.TextValue as AValue
FROM Answers AS A INNER JOIN FilledSurveys AS F ON (A.SurveyID=F.SurveyID
AND A.QuestionID=F.QuestionID AND A.AnswerID=F.IntValue AND F.SessionID =
:SessionID )
WHERE (A.SurveyID= :SurveyID ) AND (A.QuestionID = :QuestionID )

Unfortunately I found what ADOQUERY parameters parser add several parameters
with same names like

:Survey
:Survey
:QuestionID
:QuestionID
:SessionID

To solve this bug I have added first line below to query

PARAMETERS SurveyID GUID, QuestionID LONG, SessionID LONG;

Now everything look fine in ADOQUery parameters property but this time I get
error from MSSQL server that PARAMETERS function is not supported.
On Access everything works fine.

Any suggestions?

Thanks for help in advance!
Mike.


.