Fwd: Problem with Crosstabs

[tod Landis]

Dear All,
I am very interested in Entrance. I downloaded the trial version to
try it with my DB tables.
I tried Calculated Cross Table, but I don't understand why Entrance
produce a crosstab$$$ table and not only a source_table_CROSSTAB.
Any time I produce a new cross table calculation, Entrance give me the
alert saying that crosstab$$$ already exists, so I have to delete or
rename it and regenerate the calculation.
When I perform a cross table calculation (i.e. below)
[snip]
\

More to come...
- Tod

[tod Landis]

Just sent this back:

Thank you for reporting this! This was a problem.

There will be a fix for this in our next release, probably Monday.
Meanwhile, there is a development build in the test section of the
web site: http://dbentrance.com/test/(platform download)

where (platform download) is
entrance_1_6.dmg for mac
entrance_1_5.dmg
entrance.zip for Linux/Unix
enrancew.zip for Windows

- Tod

[tod Landis]

PS. You'll probably want to delete the 'crosstabs$$$'
left behind by earlier Entrance versions.

The new version continues to use a temporary table,
but it will try crosstabs$$$1, ... crosstabs10 before
giving up. It also deletes the intermediate table when
finished.

There is a note from last year about using Entrance
Crosstabs here: http://todlandis.com/Crosstabs.html.

If you don't like the idea of the intermediate tables,
you might want to investigate the pure MySQL approach
outlined here:
http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html