When I try to search in an additional info field which I have made (My Score) with the search expression {"Extra Info","My Score":10}, I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[General Info].ID=[Lists].ID INNER JOIN ([General Info] INNER JOIN [Lists] ON [General Info].ID=[Lists].ID ) ON [General Info].ID=[Extra Info].ID'.
Is this a bug or am I making a mistake?
In the queries, I have managed to do the search like this:
MyScoreQuery
SELECT "General Info"."Title", "General Info"."Date"
FROM "General Info" inner join "Extra Info" on "General Info".id="Extra Info".id
WHERE "Extra Info"."My Score" = '10';
Greets and thanks for a fantastic application!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Oh, thats right, forgot about this.
I've fixed it, and I'll release a new version as soon as I can, hopefully today, but if not today, it'll be next week.
Thanks for reminding me.
Bro
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
When I try to search in an additional info field which I have made (My Score) with the search expression {"Extra Info","My Score":10}, I get the following error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[General Info].ID=[Lists].ID INNER JOIN ([General Info] INNER JOIN [Lists] ON [General Info].ID=[Lists].ID ) ON [General Info].ID=[Extra Info].ID'.
Is this a bug or am I making a mistake?
In the queries, I have managed to do the search like this:
MyScoreQuery
SELECT "General Info"."Title", "General Info"."Date"
FROM "General Info" inner join "Extra Info" on "General Info".id="Extra Info".id
WHERE "Extra Info"."My Score" = '10';
Greets and thanks for a fantastic application!
Hi
I'll check it out and see whats going on.
Thanks for reporting.
Bro
Hey Bro,
Have you found a solution for this yet?
Thanks again!
Oh, thats right, forgot about this.
I've fixed it, and I'll release a new version as soon as I can, hopefully today, but if not today, it'll be next week.
Thanks for reminding me.
Bro
Version 2.8.6 is out.
Bro