Welcome to the Search Control v3 Demo!
 
This demo shows you how to build SQL queries and enable rich database search in your application in no time. Only task that developer needs to do is to choose wanted parameters according to his or her specific project requirements! 

If you have ANY question about this product please send us e-mail on info@beansoftware.com so we can help you. 
   
To try this demo you need to:
  1. Set search parameters using properties on the right side
  2. Write search terms in text box and click GetSQL button bellow


Returned SQL:
( album LIKE '%Bean%' AND album LIKE '%Software%' AND album LIKE '%Search%' AND album LIKE '%Control%' AND album LIKE '%Demo%' ) OR ( songlyrics LIKE '%Bean%' AND songlyrics LIKE '%Software%' AND songlyrics LIKE '%Search%' AND songlyrics LIKE '%Control%' AND songlyrics LIKE '%Demo%' ) OR ( songname LIKE '%Bean%' AND songname LIKE '%Software%' AND songname LIKE '%Search%' AND songname LIKE '%Control%' AND songname LIKE '%Demo%' ) OR ( writer LIKE '%Bean%' AND writer LIKE '%Software%' AND writer LIKE '%Search%' AND writer LIKE '%Control%' AND writer LIKE '%Demo%' )


     
Search Table Columns:




Get It!

Property

Value
SQLSyntax
TypeOfSearch
WhereToSearch
WhatColumns
UseWildCards
MultipleWildCard
SingleWildCard
SearchingLogic
DefaultOperator
MinSearchWordLength
UseColumnsFilter
UseSpecialCharacters
UseBackslash
KeywordAND
KeywordOR
KeywordNOT
IfError
MaxSearchWordsNumber
NoiseWordsTemplate