Welcome to the
Search Control v4
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 '%fast%' AND album LIKE '%superior%' AND album LIKE '%secure%' AND ( album LIKE '%database%' OR album LIKE '%website%' ) AND album LIKE '%search%' AND album NOT LIKE '%hard%' ) OR ( songlyrics LIKE '%fast%' AND songlyrics LIKE '%superior%' AND songlyrics LIKE '%secure%' AND ( songlyrics LIKE '%database%' OR songlyrics LIKE '%website%' ) AND songlyrics LIKE '%search%' AND songlyrics NOT LIKE '%hard%' ) OR ( songname LIKE '%fast%' AND songname LIKE '%superior%' AND songname LIKE '%secure%' AND ( songname LIKE '%database%' OR songname LIKE '%website%' ) AND songname LIKE '%search%' AND songname NOT LIKE '%hard%' ) OR ( writer LIKE '%fast%' AND writer LIKE '%superior%' AND writer LIKE '%secure%' AND ( writer LIKE '%database%' OR writer LIKE '%website%' ) AND writer LIKE '%search%' AND writer NOT LIKE '%hard%' )
Search Table Columns:
Song Name
Song Lyrics
Writer
Album Name
Get It Now!
Property
Value
SQLSyntax
ANSIStandardSQL
MSAccessSQL
MySQLWithLikeKeyword
MySQLFullTextSearch
MSSQLWithLikeKeyword
MSSQLContainsFullTextSearch
MSSQLContainsTable
MSSQLFreeText
MSSQLFreeTextTable
OracleWithLikeKeyword
OracleText
TypeOfSearch
ExactPhrase
AllWords
AnyWord
Expression
NotContainPhrase
NotContainAnyWord
NotContainAllWords
WhereToSearch
BeginningOfRecord
EndOfRecord
MiddleOfRecord
ExactRecord
WhatColumns
AnyColumn
AllColumns
UseWildCards
True
False
MultipleWildCard
None
Asterisk
Percent
AsteriskOrPercent
SingleWildCard
None
Question
Underscore
QuestionOrUnderscore
SearchingLogic
Boolean
Sounds
FormsOf
About
DefaultOperator
AND
OR
MinSearchWordLength
UseColumnsFilter
True
False
UseSpecialCharacters
True
False
UseBackslash
True
False
KeywordAND
KeywordOR
KeywordNOT
IfError
TwoIsOne
EmptyString
ThrowException
MaxSearchWordsNumber
NoiseWordsTemplate
EnglishUS
EnglishUK
German
Spanish
French
Italian
Dutch
Swedish
SimplifiedChinese
TraditionalChinese
Japanese
Korean
Custom