I have an application that runs on a LAN. A Listview is populated with sqlite records by another system on the network. How can I display the records saved without needing to close and reopen the Listview - auto display the recordssaved while Listview is on display.

What you are doing might require reading some changes table, updating array, redisplay current screen if necessary.There might be an easy way, but don't have a solution.

The good news:Virtual listviews and grids only need to refresh at an interval to see if something changed that is currently in view.While scrolling through pages they are current.If you sit on a page, refresh the page every so often in a loop, timer, thread using the last executed SQL statement.

'only called at an interval like every so many seconds using a timersdata = RefreshData(sql) 'get current screen dataIF sdata <> sDataBefore THEN 'something has changed sdatabefore = sdata 'set values equal 'refresh pageEND IF

I am using SQLitening in conjunction with a grid control (Farpoint's Spread). I usually add a hidden column or two for each row to save the rowID (and possibly other data) when populating the grid control with data. When any of the data is edited, it's easy to look up the corresponding rowID and update the database.

I am using SQLitening in conjunction with a grid control (Farpoint's Spread). I usually add a hidden column or two for each row to save the rowID (and possibly other data) when populating the grid control with data. When any of the data is edited, it's easy to look up the corresponding rowID and update the database.

Thank you for your response. I use the RowID trick with the Listview. I guess it would work with MLG as well. Listview and MLG implementations are so very different. Trying to wrap my head around MLG. So far so good.

I am currently trying read the cell contents of MLG into individual Textboxes.

1. PowerBASIC code can be put into a DLL and loaded from VB6.2. PowerBASIC code can use IPC (inner process communications) to talk between programs.https://10tec.com/activex-grid (many, features for grouping, etc.) 2 32-bit OCX'shttp://grid2000.com (lot of features, but less samples) 1 32-bit OCX

I have Spread 7 somewhere and used it a long time ago.I checked the current price at GrapeCity and about fell over.

I am currently trying read the cell contents of MLG into individual Textboxes.

I do that all the time with Listview. I do that mostly for the purpose of editing and saving back changes to the database through the textboxes. I guess I don't have to do that anymore with the Grid control. Users can edit the cells of a row directly on the grid and then save back to the database.