Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
Serious |
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 Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |