Page 1 of 1

Not able to open SQLite file

Posted: 23 Apr 2023, 10:28
by G8AJM
At the end of 2022 I created a new log for 2023. This was so I could see what was “needed” during the new year. This resulted in 2 databases which I’ll call “Alltime.SQLite” and “2023.SQLite”. On occasions I want to open the Alltime log and for some reason I’ve not been able to do that.

In the past when I was using Vers 1 I could swap between databases with ease by simply double clicking on the one I wanted to open, however now no matter what I try (closing one first then trying to open the other, renaming, relocating the file, attempting to open from within the program). Strangely, whatever I try the program always opens the 2023 log. When I try Settings/Config/Database I am only offered the 2023 log although both are in the same folder.

The annoying thing is that I did it very successfully last year when I went to include a completed 2022 log in the Alltime log. Trouble is I don’t recall how I did it although I suspect I opened Alltime and imported the adif of 2022.

I’ll be very grateful for any pointers here.

73 Chris G8AJM

Re: Not able to open SQLite file

Posted: 23 Apr 2023, 10:32
by G4POP
Just file/open(NEW) database

select database

click 'Open'

Save and apply

Re: Not able to open SQLite file

Posted: 23 Apr 2023, 11:01
by G8AJM
Thanks Terry but I'm only offered the 2023 file. If I choose "New" I then see both files but by choosing the alltime file I'm asked if I want to replace it.

Chris

Re: Not able to open SQLite file

Posted: 23 Apr 2023, 11:07
by G4POP
Was the all-time file a version 1 or version 2 created file?

Re: Not able to open SQLite file

Posted: 23 Apr 2023, 11:11
by G8AJM
I think I must have launched Ver2 then imported the adif of Ver1. I can't be certain but that's how I'd naturally think of it.

Re: Not able to open SQLite file

Posted: 23 Apr 2023, 11:14
by G4POP
Zip the all-time file and email to my address on QRZ please

Re: Not able to open SQLite file

Posted: 23 Apr 2023, 14:14
by G8AJM
Many thanks Terry, it looks like a Windows issue.
73 Chris