The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Re: UKHA Classified update - SQL Help!


  • To: ukha_d@xxxxxxx
  • Subject: RE: Re: UKHA Classified update - SQL Help!
  • From: steve.cooper@xxxxxxx
  • Date: Thu, 28 Mar 2002 11:23:55 +0000
  • Delivered-to: mailing list ukha_d@xxxxxxx
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@xxxxxxx


SQL 7.  But revisiting your SQL sample I see where I went wrong, I forgot
to declare my cursor as LOCAL so it was visable outside the current
instance of the procedure.

S.



"BUTLER,
Tony, FM"            To:     "'ukha_d@xxxxxxx'"
<ukha_d@xxxxxxx>
<tony.butler@        cc:
rbos.com>            Subject:     RE: [ukha_d] Re: UKHA Classified
update - SQL Help!

28/03/02
10:24
Please
respond to
ukha_d





The code I sent yesterday (think it was to group and not to graham
directly)
uses a cursor & I don't get that problem.
Works on SQL 2k and SQL 7 - what version are you using?

Tony

> -----Original Message-----
> From: steve.cooper@xxxxxxx [mailto:steve.cooper@xxxxxxx]
> Sent: 28 March 2002 10:04
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] Re: UKHA Classified update - SQL Help!
>
>
>
> >>you don't need to worry about renaimg the cursor.  variable
scope
>
> I tried it yesterday and the second time going recursively
> into the same
> procedure creates a cursor already exists error.  May have
> just been the
> way I was doing it.
>
> S
>
>
>
> ______________________________________________________________
> _____________
>
> The information contained in this message is confidential and may be
> legally privileged. If you are not the intended recipient,
> please do not
> read, copy or otherwise use it and do not disclose it to anyone else.
> Please notify the sender of the delivery error and then delete the
> message from your system.
>
> Any views or opinions expressed in this email are those of
> the author only.
>
> Thank you for your assistance.
>
> ______________________________________________________________
> _____________
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Buy Stock for $4.
> No Minimums.
> FREE Money 2002.
> http://us.click.yahoo.com/BgmYkB/VovDAA/ySSFAA/IBOolB/TM
> --------------------------------------------------------------
> -------~->
>
> For more information: http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



********************************************************************
Visit our Internet site at http://www.rbsmarkets.com

This e-mail is intended only for the addressee named above.
As this e-mail may contain confidential or privileged information,
if you are not the named addressee, you are not authorised to
retain, read, copy or disseminate this message or any part of it.
********************************************************************


For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/








___________________________________________________________________________

The information contained in this message is confidential and may be
legally privileged. If you are not the intended recipient, please do not
read, copy or otherwise use it and do not disclose it to anyone else.
Please notify the sender of the delivery error and then delete the
message from your system.

Any views or opinions expressed in this email are those of the author only.

Thank you for your assistance.

___________________________________________________________________________



Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.