[Libreoffice-bugs] [Bug 126779] Issues in File Unlocking when program is closed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126779

--- Comment #4 from NARAYAN <NARAYANVENUGOPAL at HOTMAIL.COM> ---
(In reply to Alex Thurgood from comment #1)
> @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, <<<

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190809/1794dc4c/attachment-0001.html>