FyTek Forum

Just added some new features to Report Writer for SQL processing as well as many new commands for conditional report generation based on the SQL data. The Windows version has support for Oracle 9-11g, MySQL, ODBC, CSV, and XML databases. The Unix versions currently have support for MySQL, CSV, and XML. New commands for query processing include:
QUERY
QPARAM
LOOP
RWSET
RWGET
RWIF/RWELSEIF/RWELSE
RWSCRIPT
first/firstof/last/lastof functions when looping over the query results

You can also use any Perl syntax to add as much logic as you like to the report including defining your own subroutines to use.

The documentation has a new section on SQL Queries (in the Commands section). There's a new sample report called sample_sql.frw to highlight many of the features and get you started with some CSV and XML examples. Database procedures with Oracle are also supported.

Regards,
Mike Bernardo
FyTek, Inc.

There is nothing permanent except Juicy Couture. The woman with new Juicy Couture Bags is a fashionable follow the idea succeeds.Juicy Couture Outlet lead to glory.There is no such thing as fantastic,only Juicy Couture Handbags.Juicy Couture Sale is a miniature of eternity.

You can also use any Perl syntax to add as much logic as you like to the report including defining your own subroutines to use.

The main and subtitles for paragraph vary in both name and amount. E.g. we might have the main title Suppliers (if the user has selected those for the report) and the subtitles are retrieved from the database table CompanysSuppliers. So the table of contents might include titles