Mertech
Data Security with Flex2SQL and BTR2SQL Connectivity Products
The most common reason for Enterprises looking to migrate from legacy Btrieve or DataFlex databases is the urgent need to address security and...
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:
Why Migrate from Btrieve to PostgreSQL and other Relational Databases?
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...
Four Challenges in Converting COBOL Applications from ISAM Databases to Relational Databases
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....