<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Issues in File Unlocking when program is closed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=126779#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - Issues in File Unlocking when program is closed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=126779">bug 126779</a> from <a class="email" href="mailto:NARAYANVENUGOPAL@HOTMAIL.COM" title="NARAYAN <NARAYANVENUGOPAL@HOTMAIL.COM>"> NARAYAN</a> <pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=126779#c1">comment #1</a>) > @Narayan : just a quick question to help me understand - why are you > re-creating a new database (Step 7) once you have updated your Calc sheet ? > > If your original ODB file points to the Calc sheet that you have modified, > it should automatically take up any changes you made in the Calc sheet ? We are veering off into different issue here. But anyways let me lay it out 1) Refresh table button does not refresh data. 2) There is no auto refresh. Data is refreshed only when all SBASE open programs are closed and reopened, and opening the table shows the refreshed view of the saved data from excel. 3) WHen I open sbase and open the table, and then open the spread sheet to exit data>> the excel file opens as only read only. So why is an open view of the table in database , placing the spreadsheet in read only mode? I see that dbase is designed as write/commit consistent database, similar to oracle , unlike ms sql which is read consistent. Note: In past version of MS SQL Server, Uncomitted data in MS SQL table will be viewed by other users who read data from the table. Not sure thats the case in newer versions. However..here is an analogy.. But in both types of database, viewers of data, cannot put source table under lock or read only mode. So why do , when i open dbase > open table > then open scalc > Open spread sheet > puts spread sheet in read only mode >>> Like i said this is entirely different issue, <<<</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>