RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread Christopher Olive, CIO
>cresco technologies >[EMAIL PROTECTED] >http://www.crescotech.com > > > >-Original Message- >From: Ryan [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 11, 2001 9:14 AM >To: CF-Talk >Subject: RE: Can't you use qry.RecordCount when doing an update? > > >A

RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread Ryan
.crescotech.com > > > >-Original Message- >From: Ryan [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 11, 2001 9:14 AM >To: CF-Talk >Subject: RE: Can't you use qry.RecordCount when doing an update? > > >At 10:46 1/11/01 -, you wrote: >>No.

RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread Christopher Olive, CIO
ginal Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 11, 2001 9:14 AM To: CF-Talk Subject: RE: Can't you use qry.RecordCount when doing an update? At 10:46 1/11/01 -, you wrote: >No. > >Unfortunately RecordCount is only set by SELECT, >not by UP

RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread Ryan
At 10:46 1/11/01 -, you wrote: >No. > >Unfortunately RecordCount is only set by SELECT, >not by UPDATE, INSERT or DELETE. Here is what I ended up doing, in case anyone else ever has the same problem. SET nocount ON UPDATE site SET password = WHERE siteid = #Client.siteid# AND password = S

RE: Can't you use qry.RecordCount when doing an update?

2001-01-11 Thread DeVoil, Nick
No. Unfortunately RecordCount is only set by SELECT, not by UPDATE, INSERT or DELETE. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in