Received: by 10.142.202.18 with SMTP id z18mr352068wff.46.1285716717771;
        Tue, 28 Sep 2010 16:31:57 -0700 (PDT)
X-BeenThere: dbentrance@googlegroups.com
Received: by 10.142.117.2 with SMTP id p2ls107898wfc.1.p; Tue, 28 Sep 2010
 16:31:57 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.142.247.4 with SMTP id u4mr78421wfh.49.1285716717512; Tue, 28
 Sep 2010 16:31:57 -0700 (PDT)
Received: by u4g2000prn.googlegroups.com with HTTP; Tue, 28 Sep 2010 16:31:57
 -0700 (PDT)
Date: Tue, 28 Sep 2010 16:31:57 -0700 (PDT)
X-IP: 71.134.230.160
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_4; en-us)
 AppleWebKit/533.18.1 (KHTML, like Gecko) Version/5.0.2 Safari/533.18.5,gzip(gfe)
Message-ID: <fe60325c-4bc4-4b3f-8129-e9d13a59ab79@u4g2000prn.googlegroups.com>
Subject: Entrance IDE Version 1.8.18 is up there!
From: Tod Landis <t...@dbentrance.com>
To: Entrance <dbentrance@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

There is quite a bit of new stuff in there.  I'll get some examples
into
the blog as time goes on, but meanwhile please feel free to ask
questions
here.  The IDE version gets the new chart features a little bit ahead
of the
community version as a thank you for the support.
- Tod


RELEASE NOTES
Entrance Version 1.8

-- COPY CHART
"Copy Chart" is now in the chart popup menu for copying one
chart to the clipboard.  To make its background clear, so that
whatever
is under the chart shows through, use these commands:

  NO FRAMECOLOR
  BACKGROUND RGBA(0,0,0,0)



-- FONTSIZE, TITLEFONTSIZE
These two new keywords have been added to set the size of the default
font and
title fonts in points:
   FONTSIZE (n)
   TITLEFONTSIZE (n)

You can also set font properties using
   FONT (name) (style) (size)
   TITLEFONT (name) (style) (size)
The font families available depends on the OS, but "sans serif",
"serif", and
"monospaced" are always available. The font_style can be PLAIN, BOLD,
or ITALIC.
Font sizes are specified in points.

-- HTML #rrggbb COLOR SYNTAX
HTML color syntax is now supported by the command line and servlet
versions.
(The destkop version supports it as well, but syntax highlighting will
be
incorrect)

-- IMPROVED LINE AND AREA DRAWING
Line and area drawing have been improved and are faster.  This blog
entry has
examples:  http://dbentrance.com/blog/?p=403

-- TRANSLATIONS
The PLOT syntax document is now available in Spanish:
http://dbentrance.com/newdocs/es/plotsyntax.html
as well as Japanese, French and Russian.  To switch between languages
replace
the language code "es" with "en", "fr", "jp" or "ru".  The previous
release notes
(see below) show how to add PLOT syntax notes to the Entrance Help
menu.
Please let us know if you can help with other translations!

-- First Look:  GEOMETRY Series Type
XYChart, BitmapChart, and EarthChart now support GEOMETRY columns.
These
are still experimental, but fun to play with.

A geometry column can contain geometric primitives in "Well Known
Text"
format.  Here are some examples:

     POINT(6 10)
     LINESTRING(3 4,10 50,20 25)
     POLYGON((1 1,5 1,5 5,1 5,1 1),(2 2,2 3,3 3,3 2,2 2))
     MULTIPOINT((3.5 5.6),(4.8 10.5))
     MULTILINESTRING((3 4,10 50,20 25),(-5 -8,-10 -8,-15 -4))
     MULTIPOLYGON(((1 1,5 1,5 5,1 5,1 1),(2 2,2 3,3 3,3 2,2 2)),((6
3,9 2,9 4,6 3)))
     GEOMETRYCOLLECTION(POINT(4 6),LINESTRING(4 6,7 10))
     POINT EMPTY\n"
     MULTIPOLYGON EMPTY\n");

There is a good introduction to the MySQL "Well Known Text" extensions
here:
http://howto-use-mysql-spatial-ext.blogspot.com/2007/11/using-circular-area-selection.html

This are some pitfalls to be aware of:
1) GEOMETRY series types are only supported by XYChart, BitmapChart or
EarthChart, so your script must begin with PLOT (one of those types).
2) MySQL binary geometry columns must be converted to text using
AsText().
3) There is a bug in the desktop application that causes GEOMETERY
series
to resize themselves with each repaint.

BUG FIXES
    // #468 error messages are delayed
    // #466 no frame color on rotated bar chart
    // #462 save as PNG makes chart go away when using PAGEBITMAP
TEMPORARY
    // #461 BlankChart should clear background to background color
    // #447 FRAME INSETS not working for earthchart
    // #446 Running multiple scripts from the tree does not report
errors properly