General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only