I was wondering if you can 'Refresh' a form that is using a 'Enhanced Tap
Control' ?
I have a form driven by ABC table and within a couple of the Tabs I have 'DB
Lookup ListView' all driven by temp tables, in this example tABC_parts.
One of the tabs has a DB listview and a update the ABC_parts using a button
with a eep command (if we are going to add a part) to ABC_parts.
Then refresh ABC_parts and project that into tABC_parts and refresh ABC
table seeing that the form is based off that table (all done under that eep
command).
Then (by eep command) return back to the form and think we would see the new
part in the DB Listview Not there.
What refresh am I looking for that I have missed. If I close the form and
open it - It is there. If I add a 'Refresh' to the DB Navigator it
makes no difference, nor if I add a DB Nav. to tABC_parts in the Enhanced
Tab on the form.
I can only see it by closing and reopening the form. That works fine.
I am also trying to avoid 'closewindow' and call it back up again to avoid
the screen flicker.
In this form we project 8 tables at different times to avoid network traffic
and row locking. Hence the reason for all the tTables. I soon hope to
convert it all well about 99%. (I am not worried about updates to tables
from tTables if a note was inserted and the same person is being looked at
by two or more people because the problem would be rare and if he/she is not
done the form times out and all is gone anyways. Rude, but trying to
enforce save your work policy.
EEP command:
SET VAR vresp TEXT = ' '
DIALOG 'Enter A Note' vresp vkey 2
IF vkey = '[Esc]' THEN ; GOTO aldun ;ENDIF
SET VAR who = (CVAL('netuser'))
INSERT INTO ABC_parts clientid,tndate,tnnote,tnowner VALUES
(.cid,.#DATE,.vresp,.who)
DROP TABLE tABC_parts
PROJECT TEMPORARY tABC_parts FROM ABC_parts USING *
PROPERTY table tABC_parts 'refresh'
PROPERTY table ABC 'refresh'
LABEL aldun
CLEAR VAR who,vresp,vkey
RETURN -- Back to the form
ABC .. Is an example only. The true temp table has about 40 columns and
most columns are not required to be viewed by the person opening it 60 % of
the time, but by design the user can simply scroll across or down if
needed. In the past I had it all there on the form and it becomes a visual
nightmare. DB Listview just makes it look cleaner in this form/application.
Sincerely,
Paul Dewey
