I set up a simple database in wich all works well, exept
one *very* strange (to me) result.
Some time ago I created this views:
CREATE VIEW mag_scaricati_view ASSELECT s.id_carico, SUM(s.qta_scaricata) AS ScaricatiFROM mag_scarico_tbl sGROUP BY
s.id_carico;
CREATE VIEW mag_giacenza1_view ASSELECT c.ref AS "Ref.", p.descrizione_breve AS Descrizione, c.id_carico AS
"Schedadi carico", c.qta_caricata AS "Caricati", s.Scaricati, (c.qta_caricata-s.Scaricati) AS
"Giacenza"FROM mag_carico_tbl c, mag_scaricati_view s , prd_ref_tbl pWHERE (c.id_carico = s.id_carico) AND
(c.ref= p.ref);
Now, when I issue the following command:
SELECT * FROM mag_giacenza1_view
it shows me the records that was in the database the day
I created the view, _not all the records in the database_.
If I select "by hand" with the following statament (please
note it is the very same with which I created the view):
SELECT c.ref AS "Ref.", p.descrizione_breve AS Descrizione, c.id_carico AS "Scheda di carico",
c.qta_caricataAS "Caricati", s.Scaricati, (c.qta_caricata-s.Scaricati) AS "Giacenza"
FROM mag_carico_tbl c, mag_scaricati_view s , prd_ref_tbl p
WHERE (c.id_carico = s.id_carico) AND (c.ref = p.ref);
it shows me all the records.
Please, is there anybody who can help me, I can't even imagine what's
happening. :-(((
Ciao.
--
____________________________________
Giovanni Biscuolo
mailto:giovanni.biscuolo@libero.it