Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Used to work .. I think?
Message
From
06/04/2001 19:37:04
 
 
To
06/04/2001 06:50:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00492715
Message ID:
00493114
Views:
16
Jim:

Yes, I did test it before replying to Daniel.
This was my reply to him:

It will update a brows screen at the SET REFRESH interval, but
SELECT mytable
? mytable.changed ... still does not display the new value.

SET REFRESH refreshes a BROWSE and a table.
However, in my case where the table is already in memory, SET REFRESH didn't work. Although the actual table shows the changed/new field value.
SELECT mytable (without issuing a new USE command)
? mytable.changed ... still displays the old value.

Any ideas?

Mal


>Mal,
>
>Have you actually tried???
>
>If not, then do so to confirm the documentation. I know for sure that SET REFRESH, since VFP3 now works more widely than for BROWSE. Suspect this is one of them.
>
>For those of us who rely on the docs this situation is deplorable but continues unabated since the start of VFP.
>
>Cheers,
>
>JimN
>
>
>>Daniel:
>>
>>Just checked it out.
>>Sadly ... SET REFRESH works for brows only.
>>It will update a brows screen at the SET REFRESH interval, but
>>SELECT mytable
>>? mytable.changed ... still does not display the new value.
>>
>>Thanks tho
>>
>>Mal
>>
>>>Mal,
>>>Check out the SET REFRESH command.
>>>HTH
>>>>Hi:
>>>>I thought this was supposed to work but ...
>>>>
>>>>OPEN DATABASE whatever SHARED
>>>>SELECT 1
>>>>USE mytable ALIAS mytable SHARED
>>>>
>>>>If I REPLACE a field in mytable, say field "changed", from another computer, I can't seem to get "changed" to show the new field info.
>>>>
>>>>i.e.
>>>>-------------------------------------------------
>>>>COMPUTER 1 where the database resides:
>>>>SELECT mytable
>>>>? mytable.changed ... displays "now"
>>>>-------------------------------------------------
>>>>COMPUTER 2:
>>>>REPLACE changed WITH "never"
>>>>-------------------------------------------------
>>>>COMPUTER 1:
>>>>? mytable.changed ... still displays "now"
>>>>[or]
>>>>SELECT mytable
>>>>? mytable.changed ... still displays "now"
>>>>-------------------------------------------------
>>>>If, however, I BROWS then
>>>>? mytable.changed ... displays the new info "never"
>>>>
>>>>How would I update mytable.changed without BROWS'ng
>>>>or issueing a CLOSE then USE?
>>>>
>>>>TIA
>>>>
>>>>MAL
Previous
Reply
Map
View

Click here to load this message in the networking platform