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.
Seamlessly convert from Btrieve transactional database to PostgreSQL, Oracle, and MS SQL Server.
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:
Riaz Merchant: Oct 28, 2024 6:12:41 AM
Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...
Riaz Merchant: Oct 18, 2024 9:21:56 AM
COBOL applications are the foundation of numerous essential business functions, especially within the banking, insurance, and government sectors....
Mertech: Jul 6, 2024 12:30:00 PM
Imagine breaking free from the constraints of old, monolithic systems and embracing the agility and innovation of cloud-based solutions.
Mertech