Remote view / cursor oddity
- From: Jack Jackson <jacknospam@xxxxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 13:43:01 -0800
I just ran into something that I don't understand. VFP 8 SP1,
although I doubt that matters.
With nothing open in the data environment, open a remote view:
USE track IN 0 ALIAS track_curs
* At this point 'track_curs' is the only thing open.
* The following statement apparently reads data from track_curs,
* since when it completes there is no alias 'track' open.
SELECT * FROM track WHERE ... INTO CURSOR xxx
* At this point 'track_curs' and 'xxx' are open.
* Likewise, the following statement inserts into track_curs:
INSERT INTO track .....
If the initial USE is removed, the SELECT will silently open the
remote view 'track' and leave it open, and the INSERT will insert into
that remote view, which is the expected behavior.
Is inserting into the alias when the remote view name is used the
expected behavior? It seems wrong to me.
.
- Follow-Ups:
- Re: Remote view / cursor oddity
- From: Fred Taylor
- Re: Remote view / cursor oddity
- Prev by Date: Re: The record pointer is always to the bottom of the table after Upda
- Next by Date: Take a VB6'er to lunch!
- Previous by thread: Re: The record pointer is always to the bottom of the table after Upda
- Next by thread: Re: Remote view / cursor oddity
- Index(es):
Relevant Pages
|
Loading
