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

[Karsten Hilbert]

> For your problem with molecule searching concider to update *all* CIS  
> in your DB (all tables).
> 
> >>> You can avoid my bug by adding to each CIS.CIS +10000000
> >>>
> >>> --> UPDATE CIS SET CIS=CIS+10000000 WHERE CIS.CIS>0;
> 
> Should you do :
> >>> --> UPDATE COMPO SET CIS=CIS+10000000 WHERECOMPO.CIS>0;
> 
> Don't forget CIS_CIP as well.

This is the sort of thing real foreign keys solve nicely.
SQLite doesn't fully support them, however (but certainly
serves the purpose adequately enough).

Karsten
-- 
Sicherer, schneller und einfacher. Die aktuellen Internet-Browser -
jetzt kostenlos herunterladen! http://portal.gmx.net/de/go/atbrowser