CANCEL in SCAN..ENDSCAN changes selected work area to the one being SCANned

From: Andrew Howell (ajh_at_work)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 13:31:39 +0100

I can sort of see why this is happening but didn't expect it. Just a "for
your information" post really.

* I thought "test2" would be selected when the program was cancelled
* in fact, the cursor being SCANned is selected instead

CREATE CURSOR test (test L)
APPEND BLANK
CREATE CURSOR test2 (test L)

SELECT test
SCAN
 SELECT test2
 CANCEL
ENDSCAN

* end example 

--
Regards
Andrew Howell

Relevant Pages

  • Re: Cursor for loops
    ... Your tools suite sounds like some sort of generic database development tool ... "Arun" wrote: ... >> procedure for each row then yes, you have to use a cursor or equivalent ...
    (microsoft.public.sqlserver.server)
  • Re: Cursor for loops
    ... Your tools suite sounds like some sort of generic database development tool ... "Arun" wrote: ... >> procedure for each row then yes, you have to use a cursor or equivalent ...
    (microsoft.public.sqlserver.programming)
  • Re: Cursor for loops
    ... Your tools suite sounds like some sort of generic database development tool ... "Arun" wrote: ... >> procedure for each row then yes, you have to use a cursor or equivalent ...
    (microsoft.public.sqlserver.clients)
  • Re: Cant manually move tasks (rearrange)
    ... I was in the middle of recording a macro and forgot. ... Choose Project> Sort> Sort by. ... Suddenly the cursor remains a selection arrow after I initially ...
    (microsoft.public.project)
  • Re: Do not want data to auto sort
    ... Thanks for the terribly interesting information on the term "cursor". ... As far as the interface comment, if you will read the previous posts, you ... > sort the data in a table while you are viewing it" sounds. ... > a query or Query object) possibly be mistaken for an 'interface' at ...
    (microsoft.public.access.tablesdbdesign)