As you may be able to tell, my company keeps me pretty busy with MMF2 development--which I love, since MMF2 kicks ass and ensures my job security!
I have been asked to think about how to do a new project for one of our customers... This would involve accessing a SQL database, then displaying its contents in real-time onto a grid (perhaps an MMF2 SQL database grid).
Further, envision that this customer would need to make changes to the SQL database by literally making changes to the displayed grid during run-time. Once a user makes a change to a grid cell, that content would write to the SQL database, then refresh the displayed grid with updated information.
So, aside from me learning how to use the various SQL objects and extensions that come with MMF2 (I'll have to determine which would be best to use), I thought that perhaps I would place Edit boxes on top of the displayed grid cells. Each Edit box would display the cell contents in which it was over. The user could then change values in those Edit boxes, which would then go to the database grid, then to the SQL database; once the database was updated, it would return current values to the MMF2 database, then to the Edit boxes for display.
It strikes me that this method may be cumbersome. I was wondering if there would be a better way to implement this project?
I definitely am open to ideas! Thank you very much in advance for your feedback!