Hello,
I am developing a program that uses SQLite DB. I've created two tables that are related and I have to use the INNER JOIN to get all the fields (it was meant to make it smaller). However, I can not use DBEdit, in this case because of a SQLite limitation in "views" situations (SQL changes to read-only status). So I decided to use the DBGrid and TEdit fields to promote updates to the database. I linked my "JOIN query" to a "read-only" DBGrid.
When a row is selected in the DBGrid I'd like to reflect the fields of the row in my TEdit fields. That was easy. The problem is that the Edit fields do not reflect the new value that was assigned. That is, I can not refresh the form.
Any attempt of Form.Refresh and / or equivalent results in an error. Even Application.ProcessMessages also does not work.
Putting the question in a simpler way, I'd like to have the equivalent of TDBEdit with DBGrid using TEdit fields instead. Could someone help me, please?