How does one go about displaying an MS-Access SQL Result Set In a Win32-GUI Listview (datasheet) so that the data stays refreshed? I imagine one would have to use OLE for this? Some sort of Persistant Connection to the SQL result set? Or actually wouldn't it have to be A MS-ACCESS VIEW?
I am trying to write a Win32-GUI front-end to the Access database instead of using Access Forms. Access Forms keep the datasheet views refreshed with live data. You can see the data refresh every so often. I use Win32-ODBC to connect to Access and Win32-OLE to connect to Excel. PERL Application currently pulls in data from Access into the ListView and refreshes the data only for the selected row when the end-user goes into edit mode on that row. PERL Application does a select on that row only from the database to refresh that row only. PERL application also keeps the date/time (acquired from a shared network Date Server) when that row Was fetched from the database so that when the end-user goes to save the Row, the PERL Application denies the save if another end-user has updated that Row in the database since the was last fetched. Eric
