We have just released SQLiteManager 3.7.0.
It includes the following changes:
We have also already submitted the update to the MacAppStore.
Dear Marco and colleagues,
I'm a very happy customer and appreciate the regular updates. More specifically, of the latest changes, I am very happy with the NULL and not NULL criterion that is now available in the Manage window. But (wait for it, isn't there always a but? :-)) in one aspect the upgrade seems to be a downgrade for me.
It used to be that the Manage window would stay alive with the results of its most recent query if you switched to SQL window and back again. This was incredibly handy (for me)! But we've lost it now, which means that where I would have liked to look in the Manage window to see if an update command has had the desired result I can't do so now.
It was always a source of some frustration to lose a filled-out criterion when switching tables but I can see why this was done to prevent tragic errors.. I do very much hope that 'Manage' can get its memory back; stupidly I already upgraded on all my machines..
Thanks!
Hello, we strongly agree with you and the good news is that the functionality will be restored into the upcoming 3.8.0 version (a free upgrade).
Thank you thank you!! (and look at the time stamps on the question and response! :-))
One more tiny thing: when using LIKE, case sensitivity disappears. E.g. ..where token LIKE 'Grass%' would find 'Grasses' and 'grassy', whereas token = '' has no case sensitivity issue.
I thought this was different before but I could be mistaken. And sorry if I'm bringing up things that are in a list of documented bugs somewhere on this site already!
Helma, this is not an SQLiteManager bug but a sqlite feature that you can turn ON or OFF:
http://www.sqlite.org/pragma.html#pragma_case_sensitive_like
oops... thank you! I'll get some advice locally on how to get this to work properly.
About The Author: Marco
More posts by marco