Re: [Gnumed-devel] Getting Canadian drug data into FreeDiams

[Karsten Hilbert]

On Sun, Feb 21, 2010 at 07:58:30AM +0100, Eric MAEKER wrote:

> Ok after a small correction of my code Canadian DB fully works.
> 
> You can avoid my bug by adding to each CIS.CIS +10000000
> 
> --> UPDATE CIS SET CIS=CIS+10000000 WHERE CIS.CIS>0;
> 
> Then all will work fine.

Why ?

Reason I am asking is that this smells of a MAJOR problem. I
am not asking you fix it today. Only pointing out that the
reason of this needs to be acutely aware of and fixed in one
of the next releases or hell awaits FreeDiams down that road.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346