| |
kabe さん、こん＊＊は。Hidemi Oya です。
> ところで、薬剤タブの有効成分表の効果が、製剤の効果が表示されますね。
これですが、tvSeibun ビューの問題かと思ってたら、よくよく見たら tvSeibun のベースとなっている kihon ビューがちょっと違ってました。kihon ビューを 090621test 版の「ACFinder起動後に毎回実行.qry」に入っている kihon ビューに差し替えると、有効成分毎の効果が表示されます。
CREATE TEMP VIEW kihon AS
SELECT
a.bango AS bango, shurui, meisho, tsusho, ryakusho, ippanmei,
a.seibun AS seibun, keito,
concat('・',
(select koka from koka where koka.kokaid = b.kokaid & 3),
(select koka from koka where koka.kokaid = b.kokaid & 4),
(select koka from koka where koka.kokaid = b.kokaid & 8),
(select koka from koka where koka.kokaid = b.kokaid & 16),
(select koka from koka where koka.kokaid = b.kokaid & 32),
(select koka from koka where koka.kokaid = b.kokaid & 64),
(select koka from koka where koka.kokaid = b.kokaid & 128),
(select koka from koka where koka.kokaid = b.kokaid & 256),
(select koka from koka where koka.kokaid = b.kokaid & 512),
(select koka from koka where koka.kokaid = b.kokaid & 1024),
(select koka from koka where koka.kokaid = b.kokaid & 2048),
(select koka from koka where koka.kokaid = b.kokaid & 4096),
(select koka from koka where koka.kokaid = b.kokaid & 8192),
(select koka from koka where koka.kokaid = b.kokaid & 16384),
(select koka from koka where koka.kokaid = b.kokaid & 32768)
) AS koka,
nodo, kongo, yoto, zaikei
FROM seibun AS a
LEFT JOIN m_kihon ON a.bango = m_kihon.bango
LEFT JOIN bunrui AS b ON a.ippanmei = b.seibun;
|
|
(09/08/03 9:33)
