Click on the tab, and when the table appears enter some text in the "Matchbox" at the upper right hand corner of the window. For example, enter "194", press return, and you will see all the rows that have text matching "194" in any of their fields:



Now try drawing a chart. Delete the "194" text in the match box, open the "Charts" menu and select "Line...". Click on the "+ Line" to add a line and select one of the columns in the list that appears, say "Jan". Click the "Try It" button and you will have a chart:



Now run a SQL query. Click the "New" button on the tool bar and type in the test "SELECT Jan FROM cpi_orig;", then click the "Run" button and you will see something like this:



The cool thing for SQL developers is that Entrance lets you make any SELECT statement into a chart. For example, to make this SELECT statement:

    SELECT Year, Jan FROM cpi_orig;


into a chart, you add two lines, click "Run" and you have a chart:
    PLOT
      AXISLABELS, LINE
    SELECT Year, Jan FROM cpi_orig;




More Sample Data:
Recent Eartquakes

WORK IN PROGRESS! THIS IS ONLY A TEST. HAD THIS BEEN A REAL EMERGENCY
This is the file welcome.html from the Entrance system directory
(On Macs: the system directory is ~/Library/Application Support/Entrance, ond on other systems it is ~/.entrance)

We want to use a file like this to get our usrs past the "clunk moment" when they have first installed Entrance, and have no data or scripts.

HTML anchors can be used to open other HTML files in this Entrance pane: welcome2


Anchors that start with "browse:" will be opened with the system browser: welcome2


Anchors that start with "import:" open the Import Dialog, with the named file selected: Import eqrthquake data now

Anchors that start with "sql:" open a SQL file: open color wheel example


Anchoors that start with "plot:" open and run a SQL file: plot color wheel example


Anchors that start with "table:" open a table (provided it is on the current DB tree): open table ACCESS_LOCIDS

Anchors that start with "tool:" run an EntranceTool Run Hello Swing (requires entrancex.jar)