Migrating multi-company Btrieve applications with BTR2SQL

[fa icon="calendar'] Aug 16, 2018 9:11:00 AM / by Amanda McCluney posted in Btrieve

“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.

Read More [fa icon="long-arrow-right"]

BTR2SQL 5.3 makes Btrieve LOBs SQL-accessible

[fa icon="calendar'] Jul 26, 2018 10:19:13 AM / by Matt Ledger posted in Btrieve

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.

Read More [fa icon="long-arrow-right"]

Flex2Crystal saves USA Software hundreds of development hours

[fa icon="calendar'] Jul 10, 2018 2:17:42 PM / by Amanda McCluney posted in Case Studies

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.

Read More [fa icon="long-arrow-right"]

Using parameterized queries in DataFlex embedded SQL calls

[fa icon="calendar'] Jun 11, 2018 12:38:29 PM / by Matt Ledger posted in DataFlex

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.

Read More [fa icon="long-arrow-right"]

Enhanced Debugging and Tracing in Flex2SQL Version 15

[fa icon="calendar'] Jun 7, 2018 12:37:41 PM / by Matt Ledger posted in DataFlex

In Flex2SQL Version 15, we added support for sending your application's trace output to the Windows Debug Output.

Read More [fa icon="long-arrow-right"]

Marketing in the GDPR era: 4 tips on the quest for compliance

[fa icon="calendar'] Jun 5, 2018 7:09:00 AM / by Amanda McCluney posted in News

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:

Read More [fa icon="long-arrow-right"]

How to choose the right cursor type in embedded SQL calls

[fa icon="calendar'] May 29, 2018 8:31:24 PM / by Matt Ledger posted in DataFlex

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.  

Read More [fa icon="long-arrow-right"]

Windows 10 Version 1803 Update Breaks Some Applications

[fa icon="calendar'] May 10, 2018 6:06:32 PM / by Oliver Nelson posted in News

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.

Read More [fa icon="long-arrow-right"]

Parameterized Query Support, Smarter Debugging, & More in New Flex2SQL v15.0

[fa icon="calendar'] Apr 11, 2018 10:01:34 AM / by Mertech Data Systems, Inc. posted in DataFlex, News, Webinars

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

Read More [fa icon="long-arrow-right"]

5 Must-Read Resources to Help IT Managers Prepare for GDPR

[fa icon="calendar'] Mar 12, 2018 5:16:14 PM / by Amanda McCluney posted in Btrieve, DataFlex, DevOps, Databases

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.   

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates