dbChameleon by GEConsult  v27.5.12 DEMO   SELECT * FROM demo_contacts Email us for a full-featured demo or info on acquiring this web-app.
 Current table 
Sort by   Desc   Asc
X

SEARCH FUNCTION HELP

Modifiers: ! (doesn't contain), >, <, =, >=, <= and ^ (is empty). Searches with any modifier apply to the entire field. Searches without modifiers look for any occurance of the search string within the selected field. After double-clicking the search button it reads Extend if a search can be extended with AND or OR in the operator field. The special ↑↓ operator inverts the current search.

Most searches can be saved for later use by entering a name in the "save as" field and clicking Save search. Any saved searches are available for the current table, are shown in a drop down list. Always click the Search button after selecting a saved search. A saved search cannot extend a current search.

The sndx button launches the Soundex utility which looks for a similar sounding word within a field. This is useful if a search term or target contains an apostrophe, hyphen or accented character or is a name with possible spelling variations. More detail on soundex comparisons is provided in the utility.

Block operations apply to all records returned by the current search filter. Block operations cannot be undone. Backing up is recommended before trying any block operation.
  Find  
Pg 1 of 4Rows/pg    1
Utilities



*ID
int:11ID
1
textlName
Case
textfName
Test
textPhone
555-555-5555
textEmail Click to email
textCity
Anywhere
textProv
UN
textPost_Code
Z9Y 8X7 W6V
textCountry
International
textAddr
123-B Some Street Apt. 444
textComment
SOME FUNCTIONS ARE DISABLED & CHANGES ARE NOT SAVED IN DEMO MODE
textcImage
datetime:19datedemo
2015-08-04 11:08:00
 



*ID
int:11ID
2
textlName
Ymous
textfName
Anon
textPhone
000-000-0001
textEmail
textCity
textProv
textPost_Code
textCountry
Earth
textAddr
No fixed address
textComment
This record demonstrates support for embedded base64 encoded mime graphic types. The image was converted using the geconsult.ca Encode Graphic File utility. Please note, the size for embedded graphics is displayed at a constrained maximum height of 96 px. to conserve "screen real estate." This record also demonstrates dynamically managing the way edit screen fields are generated based on record contents.
textcImage
datetime:19datedemo
2015-08-03 00:00:00
 
Pg 1 of 4      1  (7 rec)












id 
dbChameleon  v27.5.12  (© Gary Eikenberry 2009-2021) GEConsult generic MySQL database management system
This app requires JavaScript and non-persistent cookies which are cleared when the Exit button is clicked. As some functions and utilities run in a separate window it is recommended that popup blocking be disabled for this site.