Check custom reports after upsizing

Note: If you did not upsize from FH Standard to FH Enterprise, you can skip the steps below.

Standard FH and FH Enterprise support ANSI standard Structured Query Language (SQL) commands. While SQL is an ANSI standard, some products have their own versions of SQL implementation, which translate and process SQL statements in different ways. Visual FoxPro uses a different version of SQL than SQL Server (used with FH Enterprise).

Queries used by reports to gather data are converted into SQL statements. The differences in SQL implementations between FH Standard and FH Enterprise can cause problems in custom reports after upsizing to FH Enterprise.

A list of FH Standard expressions and how they are converted for FH Enterprise is available in the Appendix of the FIREHOUSE Software Enterprise Upsizing Guide.

Note: Hand-coded queries that worked in FH Standard may not work at all in FH Enterprise.

1. Run your custom reports and verify whether or not they still function as expected.  
2. (If they do not still function as expected) Contact FH technical support for assistance.