Hello,
at this time I have create an statement: select first 1 a.pfad from t_pictures a where status <> 6 and (select count(*) from t_pictures where status < 5 and kd_id = a.kd_id and li_id = a.li_id) = 0 into :pfad; pfad = path for an file Now we have thousands of records in this table and the execution takes some minutes. How can I make this statement better? I would check If there is for a record (unique with kd_id and li_id (primary key reference) one record with status < 5. If no, I can delete the folder then there is no now no picture in it. Thanks for helping. Best regards. Olaf [Non-text portions of this message have been removed]
