Batch Requests
A batch contains one or more Requests. Creating a batch gives you more flexibility in how Requests can be run. Here are some reasons you might want to create a batch: ...
What is a Request?
A Request is a Request for information from a database. The Request contains all of the information necessary to retrieve the required information. Requests run in Foxfire! will produce some sort ...
Dealing with NULLs in SQL Server
When running a Foxfire! report that uses SQL Server, an error message may appear – “Conversion failed when converting date / time from character string” Eagle-eyed readers may be able to ...
What is Foxfire!?
Foxfire! has been a powerful query and reporting tool for over 30 years. Business Intelligence wasn’t even a buzzword when Foxfire! was first introduced; yet there’s so much in Foxfire! that ...
Understanding the Sample Database
The sample database is a report environment for a car brokerage application. Below is the figure of the sample database followed by descriptions of the different items. Note: You can see ...
Foxfire! Terms
When working with Foxfire!, you may come across some terms that may not be familiar. Here’s a list of those terms. Data Dictionary lies at the core of Foxfire!. The Data Dictionary ...