![]() |
![]() |
![]() |
![]() |
Search for rows from a database table
This option lets you build a SELECT statement, a very common command in SQL. It is used to select a portion of the data available to display.
Choose the Table(s) to do the search with
The first choice which must be made is what tables will be searched. If multiple tables are chosen, this is known as a "join", and care must be taken to restrict the search later (in the conditions page) or massive amounts of information could potentially be returned. A tree of all the tables available is provided.
Choose the Column(s) to display
Next, the columns to display must be chosen. These columns will be from the table (or tables) which were previously chosen. A tree of all the possible columns is provided.
Search only for rows that have the following criteria
The WHERE clause of the SELECT command is the part of the SQL statement where particular rows are chosen. The clauses which are generated by the Sourcerer are in the form of:
WHERE columnName operator value
A list of possible columns and operators are given. The value could be another column, a numerical value, a string value, or "NULL". As the query is constructed, the SQL code is dynamically added to the list of queries above. If it is appropriate, the user may change whether a search is case sensitive by checking or unchecking the checkbox below the value. If the user desires to remove a "Where" clause, select it and press the "delete" button. To create a new query, press the "Create new" button. All the "Where" queries must be true for the row to be displayed; if different behavior is desired this can be accomplished by editing the SQL code once the "done" button has been pressed.
Data Representations, Inc. http://www.datarepresentations.com support@datarepresentations.com sales@datarepresentations.com |
![]() |
![]() |
![]() |
![]() |