Finished the last things on the ToDo list today: fine tuning the editor search and implementing search and replace.
Here are some of the latest improvements:
- Added form magnet to the help display.
- Parameterized all SQL statements.
- MessageBox dialogs were centering over the active screen, not the active form on dual monitor machines. Switched to project Jedi MessageDlg and kgInputBox, no way to test until back to work next week.
- Added Windows shortcuts (*.lnk) to list of external file types, so wiki links can now launch programs (awesome!).
- Removed link underlining in RichEdit
- Used FindEx functionality of THTMLViewer to highlight search terms.
And implemented FindNext (F3) function. - Implemented incremental search as default. This lets you perform a new search on the displayed page without having to re-query the database, which works well on pages like the autosub list.
- Added duplicate topic and blank name checking to Rename function.
- Added CSS to give borders to tables and numbering styles to ordered lists
- Added non-editable header to Sandbox page.
- Changed the date column types in the database to REAL and switched to Julian dates.
- Coded wildcard search of both the Content and the WikiWord fields, using the SQL function OR to join the query: ‘SELECT WikiWord FROM WikiPages WHERE Content LIKE? OR WikiWord LIKE? ORDER BY WikiWord ASC’
- Stopped archiving Sandbox changes
Really only one thing on the original specs that I was unable to do: add a compact database function. This functionality is only included in the professional version of DiSQLite which costs $200. I’m not willing to spend that on a program I’m giving away. I will use the SQLite manager Firefox Addon to periodically vacuum the database.
This project has come together so well, with so few stumbling blocks, that I wish I had done it years ago.