Re: Parameterized Query No rows effected
- From: "Dave Blake" <barnswood@xxxxxxxxxxx>
- Date: Wed, 27 Jul 2005 15:29:05 +0100
> Do you use the same ADOConnection for both Updates? If not then you should
> be aware of Jet Latency problem.
Yes, same connection. I am aware of Jet latency too, I don't think it
applies to this.
A query with fewer parameters works even when have just updated field22 e.g.
UPDATE MyTable
SET field1 = 9
WHERE field2 = :Param2 AND
NOT EXISTS (SELECT field21 FROM MyTable2
WHERE (field21=field1) AND (field22 <> 11) )
but pass "9" and "11" as a parameters and nothing gets updated.
Are there limits on using parameters within a subquery or SET statement?
Dave
.
- References:
- Parameterized Query No rows effected
- From: Dave Blake
- Re: Parameterized Query No rows effected
- From: Vitali Kalinin
- Parameterized Query No rows effected
- Prev by Date: Re: ADOExpress question
- Next by Date: Re: Parameterized Query No rows affected
- Previous by thread: Re: Parameterized Query No rows effected
- Next by thread: Re: Parameterized Query No rows affected
- Index(es):
Relevant Pages
|
