Bill Join me in the club favouring set pointer still beeing a valid syntax! Good news it is still working in DOS version of R:Base! Bad news it is not working in win version any longer!
Next bad news is stick to declare cursor, it is valid SQL, set pointer is not! I used to be very against that set pointer no longer are supported, but lately I have been involved in an ACCESS :R:Base integration and one lesson from that is that stick to SQL proper syntax. So nowdays I use R:Style in rbedit to get a template for declare cursor. So even if I long for the good old days when set pointer worked I have come to terms with declare cursor as well Gunnar Ekblad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of William Owens Sent: den 26 juli 2004 18:42 To: RBG7-L Mailing List Subject: [RBG7-L] - DECLARE CURSOR If anyone can help please. I've never used declare curor I've always used set pointer.. I'm trying to read plotowners table and get ownerid and seqno from table then update burial table with ownerid where seqno in plotowner table = seqno in burial table code below is not working... SET MESSAGES Off SET ERROR MESSAGES ON SET RULES OFF SET VAR Vowner INTEGER set var vseq integer declare cursor1 cursor for select ownerid, seqno from plotowners order by seqno open cursor1 fetch cursor1 into vowner indicator vi1, vseqno indicator vi2 while sqlcode <> 100 then update burials set ownerid = .vowner where seqno = .vseq and where current of cursor1 fetch cursor1 into vowner indicator vi1, vseqno indicator vi2 endwhile drop cursor1 quit Thanks Bill
