Migrate and run DataFlex applications with Oracle, MS SQL Server, PostgreSQL, MySQL & MariaDB.
Stuck in Crystal XI? Upgrade and use the latest versions of Crystal Reports with DataFlex applications.
Convert from Btrieve / P.SQL / Actian transactional engines to Oracle, MS SQL Server, and PostgreSQL
Quickly build multi-protocol web services with the same API. Supports JSON-RPC, REST, SOAP, Thrift, and gRPC.
You can create temporary tables at runtime to store intermediate results from complex queries and greatly improve your performance.
Note: Different SQL databases have different options for dealing with the scope (local or global) and lifetime of temporary tables. Refer to the online documentation for your particular database.
Download the code example here: Temporary Tables Report in VDF
The example contains code for both MS SQL and ORACLE. The example retrieves information from the CUSTOMER table (which should be present on your server), stores the results in a temporary table, and then uses the VDF WinReport Object to create the following report:
Mertech: Mar 29, 2024 8:53:00 AM
This blog post was co-authored with Riaz Merchant, President and CEO at Mertech. In the fast-paced software world, 'legacy' often signals a warning.
Mertech: Mar 7, 2024 4:32:00 PM
This post was co-authored with Riaz Merchant, President/CEO at Mertech Data Systems, Inc.
Mertech: Mar 5, 2024 5:06:00 PM
Shifting from your traditional legacy systems to the Cloud can be a game changer, as the benefits of cloud migration are numerous. Cloud computing...
Mertech