Description: - I'm working with a Base odb file. - I created this file 2 weeks ago, modified yesterday and accesed today. - I open this file, I make some changes on it (and its database) and click on Exit. When it ask me save or not to save, I choose "Not save". - I see this file properties (with Caja, from Mate Desktop) and all its data properties: "created", "modified" and "accessed" date are changed to the moment I exit Base. This report is related to another that I'm writing at the same time, that when LO save an already created file (tested in Base and Calc), it changes the three date properties. Steps to Reproduce: 1. Create a file in Base, put something. 2. Save it. 3. Open again, modify something else. Save that registry (not the file). 4. Exit Base and choose not to save. 5. Look at its date properties. Actual Results: "Created", "modified" and "accessed" date are changed to the moment I exit Base. Expected Results: "Created date" should never be touched. "Modified date" should be modified when overwritting the file. "Accessed date" should be modified when accessing it, like you do in Step 3. Reproducible: Always User Profile Reset: No Additional Info: Debian 12, x64, Mate desktop.
Here is the other report: https://bugs.documentfoundation.org/show_bug.cgi?id=161830
Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-AR (es_AR.UTF-8); UI: es-ES Calc: threaded
If you use an internal database all data you will add will be saved. All SQL-codes, which will be send, will be saved. The button, which is offered for saving in Base, will save the forms, queries, reports, macros. So: Which database do you use?
(In reply to Robert Großkopf from comment #3) > If you use an internal database all data you will add will be saved. All > SQL-codes, which will be send, will be saved. The button, which is offered > for saving in Base, will save the forms, queries, reports, macros. > > So: Which database do you use? Mhhh... I just tested it and it didn't do what you say. I opened a small file, I entered a new record in a table, I saved that record, close Base without saving. I opened the same file and the new record is not there. Maybe I'm not understanding what you say. I use a file in my computer. Maybe you mean an external db? I use Firebird as a suggestion of someone in LibreOffice-ES Telegram group.
When you are using Firebird: https://bugs.documentfoundation.org/show_bug.cgi?id=117118 Data in a database should be saved automatically. If you connect to externam databases it will be saved there when sending the SQL-command. This will be done by switching from one row to the other, pressing save in a tabel … It will be fixed for internal Firebird in LO 24.8. In older versions I prefer the macro I described for the bug above: https://bugs.documentfoundation.org/show_bug.cgi?id=117118#c9 For internal databases the extracted file has to be zipped into the Base file every time the Base file will be closed. So the Base file will be rewritten every time. For external databases there is no need to rewrite the Base file if nothing else in forms, queries … has been changed. Data will be saved without rewriting Base file.
Created attachment 195045 [details] Bug not reproducible The bug is NOT reprducible, as can see in the image all dates, "Created" (Creado), "modified" (Modificado) and "accessed" (Último acceso) are as expected. I think it is not our bug but is an OS dependent one. Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL threaded
(In reply to jcsanz from comment #6) > Created attachment 195045 [details] > Bug not reproducible > > The bug is NOT reprducible, as can see in the image all dates, "Created" > (Creado), "modified" (Modificado) and "accessed" (Último acceso) are as > expected. > I think it is not our bug but is an OS dependent one. You are right. "Created" is also untouched here. But "modified" and "accessed" are almost the same when LO has been closed (Connection to the database has been closed).
(In reply to Robert Großkopf from comment #5) > When you are using Firebird: > https://bugs.documentfoundation.org/show_bug.cgi?id=117118 > > Data in a database should be saved automatically. If you connect to externam > databases it will be saved there when sending the SQL-command. This will be > done by switching from one row to the other, pressing save in a tabel … It > will be fixed for internal Firebird in LO 24.8. > > In older versions I prefer the macro I described for the bug above: > https://bugs.documentfoundation.org/show_bug.cgi?id=117118#c9 Oh, I understand. I checked the macro and it works perfect. Thanks! I'll also wait for next LO stable version. (In reply to jcsanz from comment #6) > Created attachment 195045 [details] > Bug not reproducible > > The bug is NOT reprducible, as can see in the image all dates, "Created" > (Creado), "modified" (Modificado) and "accessed" (Último acceso) are as > expected. > I think it is not our bug but is an OS dependent one. Yes, you are right about "created date". But as this issue is more of the other report, I'll comment there what happened. To give a closure: - I understand that Base really opens the file and closes/saves it when it exits, no matter if I click on "Save" or not. So, "accessed" and "modified" date are changed by Base, but as design. - I also understand that Firebird doesn't (didn't) save automatically but new version does and there is a macro as a workaround. ... so, I close this report. Thank you very much, sorry about the mistake.