Not able to open SQLite file

Post Reply
G8AJM
Advanced Class
Posts: 39
Joined: 11 Sep 2013, 10:46

Not able to open SQLite file

Post 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
User avatar
G4POP
Log4OM Alpha Team
Posts: 10879
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Not able to open SQLite file

Post by G4POP »

Just file/open(NEW) database

select database

click 'Open'

Save and apply
73 Terry G4POP
G8AJM
Advanced Class
Posts: 39
Joined: 11 Sep 2013, 10:46

Re: Not able to open SQLite file

Post 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
Attachments
Capture.JPG
Capture.JPG (68.6 KiB) Viewed 453 times
User avatar
G4POP
Log4OM Alpha Team
Posts: 10879
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Not able to open SQLite file

Post by G4POP »

Was the all-time file a version 1 or version 2 created file?
73 Terry G4POP
G8AJM
Advanced Class
Posts: 39
Joined: 11 Sep 2013, 10:46

Re: Not able to open SQLite file

Post 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.
User avatar
G4POP
Log4OM Alpha Team
Posts: 10879
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: Not able to open SQLite file

Post by G4POP »

Zip the all-time file and email to my address on QRZ please
73 Terry G4POP
G8AJM
Advanced Class
Posts: 39
Joined: 11 Sep 2013, 10:46

Re: Not able to open SQLite file

Post by G8AJM »

Many thanks Terry, it looks like a Windows issue.
73 Chris
Post Reply