PDA

View Full Version : Grid with a Select or Join


ABC123

chadbrown
10-19-2009, 09:38 PM
There has been much talk about the fact that a grid can accomplish just about anything a dialog can do.

I am trying to find out how to do the following scenario in a grid

there are 2 mysql tables which can either select statements that join the two to view in a grid, or create a view joining
the two tables together at mysql level which seems to run faster for some reason.

My problem is that the grid will show the selected items in all the fields however when you do an update the system says you cannot update anything on the child table.

Is there any possible way to do this?

Thanks for your time.

Chad

NoeticCC
10-21-2009, 08:25 AM
Not sure about mySQL but in Oracle for example a view defined in the SQL database itself can be updateable.