Click here to Skip to main content
15,882,113 members
Articles / Programming Languages / Visual Basic

QuickWhere: create complex forms for searching into databases

Rate me:
Please Sign up or sign in to vote.
4.55/5 (36 votes)
21 Feb 20046 min read 134.4K   711   78  
QuickWhere is component that helps you in the creation of complex forms for searching into databases.
Option Strict On
Option Explicit On 

Namespace DragD

Namespace QuickWhereComponent

	Public Interface IWhereEntity

		' Generates SQL WHERE clause without the keyword 'WHERE'
		Function GetSql() As String



		' Returns value that determines whether the WHERE clause
		' generated by GetSql() is empty string

		' A WhereItem would be Idle when:
		' 1) the property FieldName returns blank and/or 
		' 2) the properties Value and Value 2 are blank
		' WithValues parameter determines whether the Value and Value2 should be examined

		' A WhereClause and QuickWhere would be Idle when all
		' contained WhereClauses and/or WhereItems are Idle
		Function Idle(Optional ByVal WithValues As Boolean = False) As Boolean



		' Determines whether the IWhereEntiry should be included into the
		' WHERE clause generated by GetSql()
		Property Used() As Boolean


	End Interface

End Namespace

End Namespace

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Tester / Quality Assurance
Bulgaria Bulgaria
I am in software engineering for 20 years.

Comments and Discussions