Re: Cursors in 5.0.13

2005-10-07 Thread Gleb Paharenko
4:05 am, Rob Hall wrote: >> >>>Having a few problems using cursors in 5.0.13 and I don't know wether >>>it's an 'operator error' :) >>> >>>Should this work? >> >>when loading a procedure, do show warnings after it.. It tells you

Re: Cursors in 5.0.13

2005-10-06 Thread Rob Hall
On Wednesday 05 Oct 2005 15:29, Jeff Smelser wrote: > On Wednesday 05 October 2005 04:05 am, Rob Hall wrote: > > Having a few problems using cursors in 5.0.13 and I don't know wether > > it's an 'operator error' :) > > > > Should this work? > >

Re: Cursors in 5.0.13

2005-10-05 Thread Jeff Smelser
On Wednesday 05 October 2005 04:05 am, Rob Hall wrote: > Having a few problems using cursors in 5.0.13 and I don't know wether it's > an 'operator error' :) > > Should this work? when loading a procedure, do show warnings after it.. It tells you what problems it

Cursors in 5.0.13

2005-10-05 Thread Rob Hall
Having a few problems using cursors in 5.0.13 and I don't know wether it's an 'operator error' :) Should this work? DECLARE cur1 CURSOR FOR SELECT DISTINCT name,addr1,addr2,addr3,addr4,addr5,town,county,postcode,telephone FROM extended WHERE centre_name != ""