Re: Remote view / cursor oddity

If you're using a remote view, there is an implied buffering mode in effect.
If you move the record pointer in the view, any changes in that record in
the view will be applied to the "source" table. Tha's the way row buffering
works. If you don't want any changes to be applied to the source table
until you're ready to do a TABLEUPDATE(), you'll have to swith to table
buffering.

--
Fred
Microsoft Visual FoxPro MVP


"Jack Jackson" <jacknospam@xxxxxxxxxxxxxxx> wrote in message
news:sc7dt19t93mfa8hjhai9369julgfvbtdf1@xxxxxxxxxx
>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.


.

Relevant Pages

  • Re: anybody out there who uses Visual Foxpro on Progress (V9) data??
    ... Have you set a buffering level 3 or 5 for the view. ... With 3, row buffering, the update occurs whenb you move off the row in the ... the connection and driver are working as expected and the problem would more ... >> It is a remote view on a single table. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Remote view / cursor oddity
    ... I don't see what buffering has to do with my problem. ... If nothing is open in the data session, and 'track' is a remote view ... USE track IN 0 ALIAS track_curs ... instead of opening a 'track' cursor and inserting into that. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Detecting clsoed socket on OutputStream.Write
    ... What causes this 'expected behaviour' to 'fail' is TCP asynchronous writing and buffering. ... If the write to the socket just goes into your local send buffer and the remote close hasn't already been detected, ... It's only when you write *after* the remote close has been detected that you can get an IOException, and this in turn can only happen if there was data still pending to be written when the remote closure occurred. ...
    (comp.lang.java.programmer)
  • Re: remote view and stored procedures
    ... Not remote views, but buffering could still be useful for form level stuff ... that catches buffer changes before navigation (i.e., ...
    (microsoft.public.fox.programmer.exchange)
  • Re: 10.4.7 Mac-to-Mac Networking: Comprehensive Report
    ... make an alias of the remote volumes (CMD L in Finder or contextual ... move the alias to the sidebar in a Finder mounted window. ... without putting it into a folder (I don't have a Favorites folder ...
    (comp.sys.mac.system)