>Hi,
>
>I have a form with Privatye data sesion.
>
>So set deleted is off.
>Also set engine behaviour is 70
>I have a local view in data enviroment with following SQL
>
>SELECT Artikli.artid, Artikli.sifra, Artikli.naziv, Artikli.cena_malo,;
> Stavki.artid, NVL(Stavki.cena_sd,0) AS cena_sd_1,;
> NVL(SUM(Stavki.kolicina),0) AS zbirno;
> FROM ;
> POPIS!ARTIKLI ;
> LEFT OUTER JOIN POPIS!STAVKI ;
> ON Artikli.artid = Stavki.artid;
> WHERE Stavki.popisid = ( ?pnpopisid );
> GROUP BY Artikli.artid;
> ORDER BY Artikli.sifra
>
>It works just one problem. It retrives deleted marked records from tables.
>
>I know that solution is to put SET deleted on in Before open tables, but it is not posible in the situation (to many forms to change, somebody before me hasn't probably heard of using derived classes...).
>
>So how to change the SQL statement to get rid of deleted records.
>
>Thanks


WHERE Stavki.popisid = ( ?pnpopisid ) AND NOT DELETED();