This is a current project, begun using 9.0 but now entirely in 9.1 so I
can't say if this did this in 9.0 as it was not this far along but I'll
try to test that and post back results.
Here are some details:
DB Grid in my form uses a 2-table view, in this case it involves Jobs
and Employees, I call the view JobTracking. The Jobs table contains
Job# and other information about a job, the Employees table Name and
other Employee data.
The DB Grid on this form is used to display a list of Jobs by Age,
Oldest first, showing Job#, Employee Name, Date, Status, and is for
display only as I'm using it kind of like a variable list view, etc. No
editing directly in this DB Grid it is strictly there to display a list.
So I have a button on the form that will allow with one click the user
to update the Status of the selected job, to indicate the job has been
received into the office for processing. Something like the following:
UPDATE jobs SET jobstatus='WIP' jobreceived=.#date WHERE ID = .vid
RECALC TABLES
When this is performed, the DB Grid on this form reflects the update.
Now I have another button that opens a Form to edit the Job information
where I can edit Job Name or some other information in the Jobs table.
When I do that and save the data, return to the form with the DB Grid,
the altered data is not reflected. Have tried the various options to
RECALC TABLES (as above), PROPERTY statements to refresh and/or CLOSE
and OPEN the view per Razzak's suggestion, etc.
So to summarize:
The DB Grid View is a 2-table view,
The edits are not from another session of R:base,
I am not trying to edit data in the View, but data directly in one of
the tables of the View,
The changes made through EEP UPDATE code (works) vs Edit Form (does not).
On 4/1/2011 7:07 PM, A. Razzak Memon wrote:
At 07:57 PM 4/1/2011, Dave McCann wrote:
Razzak: Sorry to say I just tried that and it still does not
refresh the db grid properly. As I indicated, I have a button
on same form which through code updates a column value, that
shows up, nothing when I use an edit form though. Very strange.
Dave,
You will have to provide more details. Without knowing all
details, it would be difficult to provide you with further
suggestions.
Is this something new you are doing now, or did it work
smoothly, using a previous version or update?
Also, is the underlying VIEW a single table or multi-table
view? FWIW, multi-table views are NOT updateable.
Please feel free to send all details to [email protected].
Very Best R:egards,
Razzak.
