1. Fixed an error that could happen when the DB Browser was in SQLite view and the window remained active while a search was run and then the browser was...
Dear Bart, Am trying to report on recent INR results. Have added the test node and ticked the 'units' box, yet I only have a ratio value in 20 out of 86...
Hi Jill, Most likely this will solve it for you: Select any node other than the report node and right-click that node Do SQLite, Drop a table from a SQLite...
Fixed a bug that would happen if you did FB to SQLite or SQLite to SQLite with a count in the select. When doing FB to SQLite or SQLite to SQLite (via the SQL...
Hi Les, This has been taken care of already and this is how to do it: Run your report, make sure the GP is in the output. Then right-click anywhere in the big...
Hi Bart, Is it possible to use RepAid to count the number of encounters (over a time period) where a prescription was issued, ideally split or listed by user? ...
Hi Paul, Try the attached .rcf file. Note that there the bit: ADDED_BY IN(16, 18 etc. Will need changing as that applies to our GP's. I take it you know how to...
Hi Bart, Thanks for this. I presume the numbers are the STAFF_ID numbers out of the staff table. When run, I get an error Cannot complete SQL-statement: no...
Hi Paul, Yes, if you want you can have it converted to names. The error is due to the fact that you have never run a report that looked at encounters. Run any...
Bart, That ran ok now. How can I limit the count to a certain date range, ie issues within 1 week? Can I run for all users?, so I can do all issues minus...
Hi Paul, Not sure now what .rcf you did run as I get names and counting numbers: USER ENCOUNTER_COUNT J Bright 57662 M Wilson 55700 M Ashton 55193 R Smissaert...
yes, Bart, I get names too. But I get the total count ever rather than for a defined time period. Paul. ______________ Dr Paul J Maddy paul.maddy@......
Sorry, ignore that last file. This one is fine. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of...
1. Option to vacuum the SQLite database directly from a menu. Vacuuming the SQLite database means de-fragmenting it, so it runs a bit faster and gets smaller....
Nil else than taking out a testing messagebox that I had left in. This would show as a useless message when saving a report with a macro. Version 20.92 Bart...
Fixed 2 minor bugs to do with the DB Browser in SQLite mode. First one would show the fields of a table in the wrong order if there were more than 9 fields and...
This fixes a bug that would show as an error message when you tried to drop an index in the DB Browser in SQLite mode when it said INTEGER PRIMARY KEY. This is...
Some refinements to the DB Browser. When switching from SQLite view back to Firebird view there was a data tables and fields refresh that wasn't needed. In...
Fixed a rare and harmless bug that would show in a morbidity node where you had done in the freetext box (with the A button) Show attributes but don't search...
Some fixes and improvements to do with the DB Browser. As I use this quite a lot myself I have added this option to the Options menu, so no need to add a SQL...
Some further improvements and fixes to do with the DB Browser in SQLite mode. The fields listbox right-click menu now has the option to see the SQL that...
Now uploaded to the Blueyonder site as well, plus the range name correction also needed to apply if the range name started with R followed by a number or r...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
