Controlling Locking Behavior With the SET_ISOLATION_LEVEL Command

[fa icon="calendar'] Feb 16, 2009 1:19:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

SET_ISOLATION_LEVEL controls the locking and row versioning behavior of SQL statements issued by a connection.

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

New Command: SQL_ENABLE_RECONNECT

[fa icon="calendar'] Feb 16, 2009 1:19:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

SQL_ENABLE_RECONNECT allows the MySQL Driver to automatically reconnect to the server after the connection has been closed by a time-out. In the MySQL my.ini file you can set a system variable called wait_timeout to set the number of seconds that the server will wait on a non-interactive connection before it closes the connection. The default value for this variable is 28800 (8 hours). See also the MySQL manual under Server System Variables and more specifically the variables wait_timeout and interactive_timeout.

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

New Command: SET_SESSION_PARAMETER

[fa icon="calendar'] Feb 16, 2009 1:18:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

SET_SESSION_PARAMETER OEM_TRANSLATION_STATE  allows users to programmatically enable or disable OEM to ANSI translation. Once enabled, this affects all data files used by the application. This is equivalent to adding "TRANSLATE_OEM_TO_ANSI 1" in the INT file.  SET_SESSION_PARAMETER OEM_TRANSLATION_STATE can be called at any time.

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

Write Your Own Migration Routines Using the CONVERT_DAT_FILE Macro

[fa icon="calendar'] Feb 16, 2009 1:16:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

Mertech provides a macro, CONVERT_DAT_FILE that can be called from a DataFlex program using the Mertech.inc file. This macro will migrate a DataFlex file to the target backend, creating table and index structures and copying data using the default settings of the GUI database migration tool.

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

How and When To Use MS SQL Server Native Client

[fa icon="calendar'] Feb 16, 2009 10:43:00 AM / by Mertech Data Systems, Inc. posted in Databases

SQL Native Client can be used rather than Microsoft Data Access Components (MDAC) to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features such as Multiple Active Result Sets (MARS), Query Notifications, User-Defined Types (UDT), and XML data type support.

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

New Flex2SQL v10.x Feature: Auto-Reconnect

[fa icon="calendar'] Feb 13, 2009 6:56:00 PM / by Mertech Data Systems, Inc. posted in DataFlex, News

If the server is set to time out a client connection due to lack of activity, then a DataFlex program will encounter unexpected errors if the user is not aware of losing connection to the server.  With this new feature, the driver will automatically reconnect to the server and continue from the same point where disconnect happened.

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

Using the COPY_DATA Feature With Flex2SQL

[fa icon="calendar'] Feb 13, 2009 6:56:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

The COPY_DATA feature allows the user to copy data from an SQL table to a DAT file and vice versa.
Flex2SQL has two options that allows us to copy the data from a DAT to a SQL and vice versa, but our customers prefer a single command approach.

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

New Flex2SQL v10.x Feature: External INI File

[fa icon="calendar'] Feb 13, 2009 6:50:00 PM / by Mertech Data Systems, Inc. posted in DataFlex, News

Mertech provides a lot of tweaking options (especially in DataFlex) to control the workings of the driver. These have previously only been available through Macro commands, which has meant that to test them out, the application would have to be recompiled.

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

The MCS Group Chooses Mertech to Migrate to Industry-Leading MS SQL

[fa icon="calendar'] Oct 14, 2008 7:21:00 PM / by Mertech Data Systems, Inc. posted in Btrieve, News

Pembroke Pines, FL

The MCS Group, Inc. provides outsourcing solutions for record retrieval, document support, facilities management, and correspondence management. Since 1979, MCS has grown to become the recognized leader in outsourcing solutions to law firms, insurance companies, corporations and government agencies. With offices around the U.S., MCS works to assist their customers in making staff support costs as simple, efficient and economical as possible.

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

Mertech to Present at Dallas Technology Days

[fa icon="calendar'] Sep 26, 2008 7:22:00 PM / by Mertech Data Systems, Inc. posted in DataFlex, News

October 2-3, 2008
Fort Lauderdale, FL

Mertech Data Systems and the Dallas/Fort Worth Dataflex User Group are pleased to confirm that Riaz Merchant, Mertech CEO, will be attending the annual Dallas Technology Days in Dallas, Texas October 2-3, 2008. All Visual DataFlex developers are invited to this technology-oriented conference.The conference’s goal is “to cover as much as possible with actual hands-on, under-the-hood style information.”

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

Subscribe to Email Updates