![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
| Reported By: Uli Becker Reported On: 7/20/2009 For: Version 2.02 Build 15 |
with SearchQuery do
begin
close;
sql.clear;
sql.add('select distinct FoldersID, Created, Caption as Mappe, Titel as Buch, BooksID,');
sql.add('Protected from Scans s join Folders f on s.foldersID = f.foldersID');
sql.add('join Books b on b.BooksID = f.BooksID');
sql.add('where (BenutzerID = :FBenutzerID) and (ocr contains :FSearchText) ');
sql.add('union');
sql.add('select FoldersID, Created, Caption as Mappe, Titel as Buch, BooksID,Protected');
sql.add('from Folders f join Books b on b.BooksID = f.BooksID');
sql.add('where (BenutzerID = :FBenutzerID) and ');
sql.add('(Caption like :FSearch or Search like :FSearch) ');
sql.add('order by created desc');
prepare;
end;This web page was last updated on Wednesday, April 8, 2026 at 04:38 AM | Privacy Policy © 2026 Elevate Software, Inc. All Rights Reserved Questions or comments ? |

