Re: Parameter object is improperly defined. Access vs MSSQL

From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
Date: Wed, 29 Jun 2005 22:22:05 -0500

>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?

Rename some of your Parameters so you don't use a parameter name more than once
in your query
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

References:
- Parameter object is improperly defined. Access vs MSSQL
  - From: Mike Meyer

Prev by Date: Re: Update and insert in one sql statement in access error
Next by Date: Re: Delphi 2005
Previous by thread: Re: Parameter object is improperly defined. Access vs MSSQL
Next by thread: Update and insert in one sql statement in access error
Index(es):
- Date
- Thread

Relevant Pages

RE: how do I set up a registration form
... I then cut and pasted the SQL statement into the code adding quotation marks ... there will be many students that attend. ... The name of the control that contains the SessionID in the Where clause ... Query By Design view. ...
(microsoft.public.access.forms)
RE: Using a subform to display and add info into table
... - Did you create a query by cutting & pasting the INSERT SQL statement into ... - With the Attendance form open, with a SessionID and SessionDate entered, ... >> Each instance will have many students, and, in fact, the same students that ... >> a combo box for the SessionID (with the same properties as the one on your ...
(microsoft.public.access.forms)
RE: how do I set up a registration form
... I think the problem is in the reference to your form control. ... the SessionID equals 15. ... there will be many students that attend. ... Query By Design view. ...
(microsoft.public.access.forms)
RE: how do I set up a registration form
... I think the problem is in the reference to your form control. ... the SessionID equals 15. ... there will be many students that attend. ... Query By Design view. ...
(microsoft.public.access.forms)
Re: Survey Design
... The first thing you'll need to do is build a query that joins tblAnswers ... QuestionID, drag the QuestionID from tblQuestion to tblAnswers. ... you have room to add a new subform in your tblAnserSession_Subform. ...
(microsoft.public.access.tablesdbdesign)