Updating a data environment and flex-grid at run-time

[ii128]

I have a Data Environment, call it deMyDatabase, with a connection to a database, conMyDatabase. In the connection I have a command, Renters, which connects to the RenterInfo table in my SQL database. The command also has a subcommand,
MonthlyPayments, which connects to the MonthlyPayments table in my database.

On my form I have an MSHFlexGrid, which is linked to the Renters command. The flex grid is set to display combined data from the Renters table and the MonthlyPayments table, so I can see the list of monthly payments for each renter.

Question: When I add a new tenant at run-time, or modify tenant information, how do I dynamically tell the MSHFlexGrid to update?

I am updating the database using another form, with an ado control that connects to the database. In my update subroutine, I need a command that tells the flex grid --
or that tells the Data Environment commands, which feed the flex grid -- to go back to the database, and read the updated data (and show it in the grid, of course).

I have tried a variety of commands, such as deMyDatabase.rsRenters.Update
deMyDatabase.rsRenters.Resync

.Update simply does nothing. .Resync gives me the error message: "Insufficient table information for updating or refreshing." There is no .Refresh command. I have tried
other plausible methods, to no avail. Any suggestions?

 

[stnkyminky]

There should be a refresh or update associated with the MSHFlexgrid. Try that.......... Scott
Programmer Analyst

 

[ii128]

I have tried. There is no refresh for MSHFlexgrid.

 

[stnkyminky]

I have a MSHFlexgrid in a project, I'm looking at it right now, and the grid has a refresh property.


ex. msgjobs.refresh

Please verify Scott
Programmer Analyst

 

[ii128]

I am updating the database using another form, with an ado control that connects to the database. and I have tried the refresh property, the data in MSHFlexgrid still contain the old data.