5 Replies Latest reply: Oct 19, 2012 5:31 AM by 642068 RSS

    VO created from Multiple EO, problem.

    642068
      Hi, I created VO from 3 EO

      First VO:
      SELECT Izolati.BEIGU_DATUMS, 
             Izolati.DNS, 
             Izolati.GINTS, 
             Izolati.IZOL_1H_1S, 
             Izolati.IZOLATA_APRAKSTS, 
             Izolati.IZOLATA_NUMURS, 
             Izolati.IZOLATA_PIEDERIBA, 
             Izolati.IZOLATI_ID, 
             Izolati.IZVEID_DATUMS, 
             Izolati.IZZ_MIC_DNS_IZDAL, 
             Izolati.KLASE, 
             Izolati.KOLEKCIJAS_IDENT, 
             Izolati.PARAUGA_ID, 
             Izolati.PIEZIMES, 
             Izolati.RINDA, 
             Izolati.SAGL_H2O, 
             Izolati.SAGL_OMA, 
             Izolati.SAGL_PDA, 
             Izolati.SUGA_IZOLATAM
      FROM IZOLATI Izolati, PARAUGI Paraugi, SAIMNIECIBAS Saimniecibas
      WHERE Izolati.parauga_id = Paraugi.paraugi_id and Paraugi.saimn_nosaukums = Saimniecibas.saimn_nosaukums and Saimniecibas.saimn_nosaukums = :bindSaimn
      Using this VO I can delete rows from Izolati table.

      I have another VO from the same EO, but there I can't delete data from Izolati table:
      SELECT Izolati.BEIGU_DATUMS, 
             Izolati.DNS, 
             Izolati.GINTS, 
             Izolati.IZOL_1H_1S, 
             Izolati.IZOLATA_APRAKSTS, 
             Izolati.IZOLATA_NUMURS, 
             Izolati.IZOLATA_PIEDERIBA, 
             Izolati.IZOLATI_ID, 
             Izolati.IZVEID_DATUMS, 
             Izolati.IZZ_MIC_DNS_IZDAL, 
             Izolati.KLASE, 
             Izolati.KOLEKCIJAS_IDENT, 
             Izolati.PARAUGA_ID, 
             Izolati.PIEZIMES, 
             Izolati.RINDA, 
             Izolati.SAGL_H2O, 
             Izolati.SAGL_OMA, 
             Izolati.SAGL_PDA, 
             Izolati.SUGA_IZOLATAM
      FROM SAIMNIECIBAS Saimniecibas, PARAUGI Paraugi, IZOLATI Izolati
      WHERE Izolati.parauga_id = Paraugi.paraugi_id and Paraugi.saimn_nosaukums = Saimniecibas.saimn_nosaukums and Saimniecibas.saimn_nosaukums = :bindSaimn
      The only thing that I see, that EO in FROM clause is in different order. Can anyone explain my problem, what happens?

      Best regards, Debuger!