nr wrote:
I'm trying to write an SQLite3 program to delete history older than 3
days and was hoping some folks here might be able to help with a few
items I can't figure out. I haven't found complete documentation for
the product.
1. What is the syntax to tell the program which database to use
(places.sqlite)? On mainframes and minis this is referred to as file
allocation or file definition.
2. What is the best way to compare the current date to the dates in
the table?
If I can get this to work, I'll be happy to post it here for anyone
who wants to copy and use; it will run from a .bat file.
Any other ideas or suggestions are welcome.
Thanks for any assistance.
One of the top items on my personal wish list is a much better toolkit
for managing the history in the program itself:
1) There's no way to select and delete multiple items (standard Windows
shortcuts such as CTRL-click for discontinuous items, SHIFT-click for a
range don't work). If you want to delete more than one, you have to keep
hitting Del, Del, Del, ...
2) If you select and delete a website from one part of your history
(say, last Thursday), the program stupidly deletes all occurrences of
that website anywhere in your history. If you want to just delete last
Thursday's history for that site, you have to expand it and delete them
manually one... at... a... time.
3) There's no longer an option to autodelete history items older than nn
days ("remember visited sites for up to nn days"). There's a button in
the prefs to "Clear history," but that's all or nothing.
--
War doesn't determine who's right, just who's left.
--
Paul B. Gallagher
_______________________________________________
support-seamonkey mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-seamonkey
