Re: ADODataset: Query parameter used twice in the SQL satatement
From: Jim Albertson (jimalbertson_at_yahoo.co.uk)
Date: 08/09/04
- Previous message: Anton Santa: "Re: Little help needed"
- In reply to: Michael Jacobs: "Re: ADODataset: Query parameter used twice in the SQL satatement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 9 Aug 2004 10:47:40 +0430
"Michael Jacobs" <iq193@earthlink.net> wrote in message news:41169d9d$1@newsgroups.borland.com...
>
>
> Hi Jim,
>
>
> You don't specify how you are setting the value of the parameter, so I am
> assuming you are using the 'ParamByName' method. What is happening is when
> the SQL statement is examined to set the parameter a match is found on the
> 1st occurrence of 'MY_TIME_IN' and that conditions ends the search for a
> matching parameter. The problem you are encountering is that you have 2
> parameters in your statement even though you assigned the same name to them
> they are separate and distinct objects within the SQL statement.
>
>
> I hope this explanation helps.
>
>
> Regards,
>
>
>
> Michael
>
hmmm.... so.. it is a feature..
thanks Micheal.
JA
- Previous message: Anton Santa: "Re: Little help needed"
- In reply to: Michael Jacobs: "Re: ADODataset: Query parameter used twice in the SQL satatement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
