Re: [Care2002-developers] Interesting: freediams, perform prescriptions and check for pharmaceutical drug interactions

2010-10-15 Thread Robert Meggle
Hi Muthu, In fact, that is strange. Such databases are great when they are holding these data and it could be used in different ways. But let us look on it... I will give Mauri some instructions how he can look for that data and give us some feedback if we can use it. Thanks again for that rea

Re: [Care2002-developers] Interesting: freediams, perform prescriptions and check for pharmaceutical drug interactions

2010-10-15 Thread Ap.Muthu
On analysing the FreeDIAMS database, we find duplications in the DRUGS table: SELECT UID, COUNT(*) AS Records FROM DRUGS GROUP BY UID HAVING Records > 1; UIDRecords 21045002 2 21998001 2 78665001 2 We also find that the COMPOSITION table has many UIDs duplicated, but unique if a comp

Re: [Care2002-developers] Care2002-developers Digest, Vol 52, Issue 27

2010-10-15 Thread Robert Meggle
Hi Hassan, > Robert, > I have looked at the database and the drugs are actually populated in > the care_tz_drugsandservices table but it is not displaying in the > prescription list. > > I have also looked at the code and it seems that the code is trying to > pull drug data from webERP which

Re: [Care2002-developers] Care2002-developers Digest, Vol 52, Issue 27

2010-10-15 Thread Hassan Awodi
On 15/10/10 13:03, care2002-developers-requ...@lists.sourceforge.net wrote: > Send Care2002-developers mailing list submissions to > care2002-developers@lists.sourceforge.net > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/