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
Vladimir Martinovski
VCS Software Inc.
"May the FOX be with You"