Sorry, I wasn’t clear enough → Argen as such isn’t the way to go as the sqlite database is generated in code and will be different each time it is generated.
To be more specific. I have written an application that generates random allocation to different treatment arms for a clinical trial. The next step is to ask the user what measurements they want to make and what treatment outcomes they are looking at, This information is added to a listbox. Once the user is satisfied with this, an SQLite database is generated. In the next step, the fields that are constant are displayed in a listbox. What I want to do next is to display the fields from any individual record he database in a window so that those fields that are empty can be completed (measurements, outcome measures). The structure of the database will vary according to the decisions made in a previous step.
Hence my desire to know how to identify the structure of the database and to display the column headings on the window by code, and place textfields next to them for data entry.
I am looking at the Xojo documentation, but would appreciate any guidance in this area. It is an interesting challenge.
I guess what you are suggesting is to dig int the Argen code to see how it is fine there, but I am finding that challenging.