why refresh() command doesn't show me the latest data from the table on my form. I have to manullay select refresh from menu to see the changes in the table. Is there any other command?
I am on Baan IV c4

Refresh() only moves internal screen modifications to the terminal display, not record set data.

Use execute(find.data) to refresh the current record set.

also refer to the function -

Syntax

void refresh.curr.occ()

Description

This reads the current record and refreshes it on screen. All references on the form are read again. For example, in the case of a zoom from a field to a session where the record can be modified, calling refresh.curr.occ() refreshes the occurrence on the parent form also.
Note that the function locks the record before reading it; this is necessary for delayed locks.

Context

4GL library function.
You can use this function only in 4GL scripts. You cannot use it in programs of type 4.

execute(find.data) is working.

If you dont want to perform the routine execute(find.data) or you cant perform it, use the following function that works fine for the GUI interface (it´s a standard baan function, bshell)

wrebuild(1) or wrebuild(0)

1 rebuilds the current window.

I found another tools function - make.current() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_form_and_form_field_operations_make_current)

put

display.all()

before the refresh() command.

NOTE: Its mentioned in the - Application Performance Guide - M2017 B US.pdf - Chapter 2 - Programming Constructs.

2.5 Functions display(), refresh(), disable.fields(), enable.fields(),
disable.commands(), enable.commands().
Problem
Functions display(), refresh(), disable.fields(), enable.fields(), disable.commands() and
enable.commands() cause network traffic from the user-interface application-program
to the user-interface itself.
Solution
Reduce the network traffic by removing superfluous implementation of these
functions.
Superfluous calls can be traced by running the script in debug mode.

Originally posted by NPRao
NOTE: Its mentioned in the - Application Performance Guide - M2017 B US.pdf - Chapter 2 - Programming Constructs.

OK, what's the best solution in regard to network traffic?