Print filter gives SQL error

Discussions about Diving Log 6.0 - questions and hints
Post Reply
FL-Diver
Posts: 13
Joined: Tue Nov 28, 2023 23:42

Print filter gives SQL error

Post by FL-Diver »

Hello Sven, many thanks for the continued help.

The search and filter for the logbook works fine.
image1.PNG
image1.PNG (10.46 KiB) Viewed 49666 times

The same print filter gives a SQL error.
image2.PNG
image2.PNG (20.29 KiB) Viewed 49666 times
image3.PNG
image3.PNG (19.22 KiB) Viewed 49666 times

Thank you again.
FL-Diver
Posts: 13
Joined: Tue Nov 28, 2023 23:42

Re: Print filter gives SQL error

Post by FL-Diver »

Ok. The print filter works fine for divetype so this appears to be something with place. Please note my place list is empty.
image4.PNG
image4.PNG (16.69 KiB) Viewed 49664 times

Could the logbook filter "place" be looking at the dive site names, but the print filter "place" be looking at the place list?
FL-Diver
Posts: 13
Joined: Tue Nov 28, 2023 23:42

Re: Print filter gives SQL error

Post by FL-Diver »

I created a test site named "Test" and changed one dive to use this site. The logbook search and filter functions work fine. However, the print filter still gives a SQL error.
divinglog
Site Admin
Posts: 5844
Joined: Sat Feb 08, 2003 21:02
Location: Coburg
Contact:

Re: Print filter gives SQL error

Post by divinglog »

I think this is currently not possible in the print function, because of naming conflicts in the existing SQL query.
Post Reply