“What’s the best way to migrate a multi-directory Btrieve database to a SQL backend?” It’s a question that comes up often, considering that in SQL, different tables with the same names will collide if stored in the same database.
Over the years, one specific portion of a Btrieve record has given some of our customers trouble. That's the variable portion, the bit that allows you to store up to 2GB of additional, unstructured data within a record using Large Objects (LOBs), in excess of the record's "fixed" 64K data limit.
Here’s a scenario that anyone with tenure in the software business can relate to: you get the news that one of your most essential applications will be going in a new direction soon. In the case of F.A. “Woody” Spencer, President of USA Software, this news came from Crystal Reports, making the announcement that their long-used COM-based interface would soon be replaced with a .NET solution.
In Flex2SQL v15, we introduced the ability to use parameterized queries within your DataFlex application’s embedded SQL calls. Developers have been asking for this feature for a long time, and for good reason.
In Flex2SQL Version 15, we added support for sending your application's trace output to the Windows Debug Output.
Like so many other companies offering products and services to a global audience, the Mertech team recently turned our attention to data, privacy, and new data protection laws going into effect, such as the General Data Protection Regulation. The conclusion we drew was an easy one:
Flex2SQL for Microsoft SQL Server allows developers to use either client-side or server-side cursors in their embedded SQL queries. In Flex2SQL Version 15, we significantly improved these queries' performance, so your DataFlex app can conduct embedded SQL queries even more quickly.
We have received multiple reports of problems accessing database servers from within applications after updating Windows 10 to the latest version 1803. This same issue is being reported in DataFlex, VB6, VB.NET, Delphi, and other languages as well.
Flex2SQL’s recent Version 15 release includes a series of exciting, asked-for new features, plus a significant performance increase in embedded SQL calls - up to 5 times faster than previous versions!
With the May 25th deadline looming closer, it’s easy to find resources on the topic of the EU’s General Data Protection Regulation and what it will mean for organizations around the globe. In fact, a search query now yields so many results that it becomes overwhelming trying to sort through them all; some facts are repeated over and over, while other questions seem to go unanswered no matter how you search for them.