The iSOFT User Group is holding its Annual Conference in Daventry on Thursday and Friday Oct 9-10. Part of the proceedings will be what we are calling 'The...
Some further improvements to the DB browser (launched with the DB browser button in the SQL node): 1. The stats column is now displayed differently, so that...
Fixed a simple SQL logic bug that could cause an error message when running a drug node with Adverse (drug allergies) in the Entry type box and with no filter...
Some fixes to do with the new Firebird and also some adjustments to the code to do with keys in the file sys6000.ini that I wasn't aware of, to do with picking...
Hi John, No, nil at all, it should just pick up the changes automatically. Make sure you are on the latest 20.12. One thing to mention is that I don't think...
Hi Paul, I know that list connected users doesn't work with Firebird and that is to do with the Classic version of Firebird, rather that the so called Super ...
Bart I still get a message in the status bar about checking for other logged-in users and then get a message that says "for some reason this didn't work" Paul ...
Something of relevance to all Rep-Aid users: The sys6000.ini file can have this key in the [Database] section: DBPath=/meddata/s6000/db/s6.gdb If you are on...
This fixes a possible problem when Synergy 1.9 is installed and when the connection is done via the Synergy API, that means it picks up the loging credentials...
Fixed one possible connection problem with the new Firebird database. As mentioned before showing the connected users does not work with this version of...
Some fixes and improvements to do with demo/questions at the conference. 1. Adding a sheet range of Read codes and terms to multiple nodes in the treeview...
With the new search check (checking all the parameters before running the search) I had overlooked the fact that the first Read code box in the morbidity node...
Hi Bart As you know we have a practice licence and I wanted to install Rep-Aid onto another PC. I ran S:\ExcelAddins\ExcelReportingAddin_Setup.exe on the PC,...
Hi Les, Yes, this is something I was just made aware of by Martin Rowlatt and will fix this hopefully this morning and upload a new file, 20.17. Bart...
Hi Bart I had to download manually, but it's all working now. I'm getting a 13 day warning that our licence is about to expire. Les Les Trewinnard (Practice...
This will now reliably show the exact end date of the licence as it won't read the file date anymore from the licence file. Simplest way to see the licence end...
Hello All, Is it possible to export data from the Synergy address book? We are especially interested in the Consultants and Hospital/Provider data. Thanks, ...
Hi John, Yes, that can be done. It will depend a bit on exactly you want to see, but something like this will do it: Add a SQL node. In the big SQL box on the...
Thanks Bart, That worked very nicely. Would you mind posting the sql for hospitals and hospital addresses as well please? Many thanks, John _____ From:...
Hi John, Try this one: select distinct o.organisation_name, ee.description, o.abbreviation, o.organisation_code from externalperson_externalsite ee inner join...