Best of all, Foxfire! is completely customizable! You can
add calculated fields to its dictionary, control each user's
data access and privileges, and even add custom features to
remove all the techno-barriers for the end user. Foxfire! makes
it possible for them to create nearly every kind of report
without assistance.
Foxfire! includes an unconditional 60 Day Guarantee!
Visual FoxPro 6.0 Users: After your purchase Foxfire!
you will need to download the following file. ffnvfp6.exe. The self-extracting zip file
contains a readme.txt and 3 program files that will need to be
replaced in the current Foxfire!
Enterprise Developers Edition
Support for Access, MS Sql Server, Oracle, and Sybase
databases
The Enterprise Developers Edition supports querying the above
databases using ODBC and SQL Passthrough.
Support for the SQL JOIN clause and Outer Joins (for qualified
ODBC datasources)
Foxfire! can build Sql joins using the JOIN clause syntax. This
allows you to build Requests with INNER, LEFT, RIGHT, or FULL JOINs
specified on each join in the Request. Previous versions of Foxfire! were
limited to two table outer joins. Now you can specify as many outer
joins as allowed by the particular database queried (VFP limit is about 9
joins).
Foxfire! will still build joins using the WHERE clause. You can configure
Foxfire! to default to using either the JOIN or WHERE clause. Whatever
the default, each individual Request can also specify the join style used,
overriding the Preference default.
User Interface Overhaul
Foxfire! has had an extensive user interface makeover. The Request
Manager has been completely redesigned using Windows standard
ActiveX controls. Nearly all screens have been rebuilt as VFP forms and
all controls all subclassed from Foxfire! base classes. We have tried to
maintain the look and feel of modern Windows applications (no bold
fonts, etc.).
Request Folders
As part of the new Request Manager interface, you can now better
organize all your Requests into folders. The Request Manager now
includes the Request Tree, allowing you to group Requests into folders
with a Windows Explorer like interface.
Request Wizards
There are now Request Wizards for each Foxfire! Request type. New
users can now use a wizard to step through the Request creation
process. The wizards are designed to conform as close as possible to
the Windows 2000 wizard design guidelines.
User Login and User Manager
Foxfire! has a built in user management system. You can control
access to Foxfire! with a User Id and Password login, and you can
specify a default printer, user permissions and privileges on a
user-by-user basis.
Support for SQL TOP N/PERCENT (for qualified ODBC
datasources)
You can now perform TOP N queries using the SQL TOP N clause. The
new TOP N clause also supports a PERCENT option.
Improved Join Building Engine
Foxfire! has an improved SQL builder to help resolve circular
relationships in the database table schema. Previous versions of Foxfire!
did not allow any circular relationships.
To support the new engine, Foxfire! introduces the concept of the
Join Tree. Foxfire! has always maintained metadata for how the tables in
your application are joined. Using the Foxfire! Relationship Editor utility,
you now can specify the hiearchial relationship between tables as well,
which when completed produces a Join Tree of all the relationships in
your database. The Join Tree makes it possible for you to specify outer
joins between two tables by clearly representing which table is the
Parent and which table is the Child in the relationship.
Importing and Exporting Requests
The Import and Export utilities allow a developer or users to distribute
Requests between disconnected Foxfire! installations. A Request export
file can be created and sent to another site for importation into another
system.
When you select Requests to export, you can also specify to include
associated Data Items used in the Request. This includes Data Items
used for any part of the Request; Fields list, Filters, Sorting and
Grouping, etc.
Any custom FoxPro report layouts associated with the Request can
also be imported and exported.
To make the importing and exporting as simple as possible, all the
exported metadata, the Request records, the Data Item records, and the
complete Layout structure (.frx file), are combined into a single XML
document. Using XML makes it possible to normalized all the detailed
metadata that's stuffed into Foxfire! Request record structures, and just
as importantly, allows for the creation of a single import/export file
instead of having to bundle many different file fragments together for
distribution.
Custom Ask-at-Runtime filter UI controls
You can now specify for each data item in the data dictionary an
associated user-interface control to be instantianted within the
Ask-at-Runtime (AAR) filter dialog when the data item is used as an
AAR filter. This allows you to utilize any custom UI controls you have
within your application within Foxfire! as well, or you can create new
custom UI controls specific for Foxfire! AAR filter data entry
requirements.
Query Log
You can now setup Foxfire! to output all query statistics to a log. This
log can then be viewed to analyze the activity within your Foxfire!
system.
Y2K Compliance Updates
Foxfire! no longer uses CTOD functions and date constants use the
{^yyyy-mm-dd} format (including date constants in SQL generated for
VFP data sources).
Visual FoxPro DBC Setup Improvements
When using the Setup Wizard to load tables from a VFP DBC, field
name captions, inputmask, and format are captured into the
dictionary.
Online Reference Manual
The Reference Manual is now available on-line in HTML format. This
documentation will be constantly involving an improving as more useful
information and tecniques become available. This "live" documentation
can constantly be updated from the Micromega website.
Web Publisher
Foxfire! includes the Foxfire! Web Publisher free. The Web
Publisher allows users to run Foxfire! Requests from a browser over an
intranet or the internet.
Foxfire! Enterprise Developers Edition
The Enterprise Developers Edition includes all the
functionality of the Standard Developers Edition and adds
the ability to query and report from the following ODBC
datasources:
- MS SQL Server 6.5/7.0
- Access
- Oracle
- Sybase ASE
The Enterprise Edition is licensed by concurrent seat
(refered to as an End-user license). End-user licenses are
needed for creating and editing reports. A royalty free
runtime is included to allow an unlimited number of users
to run existing reports. The Developers Edition includes a
single End-user license and source code.
Enterprise Developer's Edition comes with source code, FoxPro project components, and a single user license for the Report Designer (this license cannot be distributed to end users however). With it, you can create a customized report writer that you can distribute with your application.
Foxfire! Enterprise Edition Report Designer licenses are required so that users may create reports. You don't need to have a license to run the reports or customize the FRX-generated layout.
These licenses are limited to the same network and may not be distributed.
Home ||
Shopping Cart ||
Site Map ||
Newsletter/Blog
Search HALLoGRAM ||
Request More Information
CALL TOLL FREE 1-866-340-3404
Today's database users expect to create queries and reports
themselves -- without special training or help. And they know
it takes more than drag-and-drop selections to make it easy.
Real expertise is required to join files, create expressions,
etc. But with most report writers, these tasks are just too
confusing for most end users.