Mertech Flex2SQL Tech Blog

Execute a Stored Function using the SQL_SET_FUNCTION_NAME Command

helenh — Fri, 11 May 2012 17:44:28 +0000

SQL_SET_FUNCTION_NAME The SQL_SET_FUNCTION_NAME command allows you to execute a previously stored function. Call SQL_SET_FUNCTION_NAME passing the function name and number of parameters the function is expecting. Next, pass each parameter individually using SQL_SET_FUNCTION_PARAMETER. Once all parameters are passed, execute the function with SQL_FUNCTION_EXECUTE. Finally, retrieve the result through a call to the SQL_GET_FUNCTION_RETURN. DataFlex code example: String sPar1 Number iPar2 Date [...]

Restore Codejock Controls to Resolve Flex2SQL GUI Runtime Error

helenh — Fri, 11 May 2012 16:57:26 +0000

A few customers have reported unexpected problems running the Flex2SQL GUI. Error messages have been observed indicating that the TERMLIST.CFG file is missing and/or that an unhandled program error occurred. The Problem This problem occurs if VDF15.0 is uninstalled. Required runtime files and Codejock OCX controls, which are used by the Flex2SQL menus, are removed when VDF15.0 is [...]

Fetching Multiple Resultsets using the SQL_NEXT_RESULT_SET Command

helenh — Tue, 01 May 2012 15:39:05 +0000

You can enter multiple SELECT statements in a stored procedure to retrieve multiple resultsets and then use SQL_NEXT_RESULT_SET in the client code to position the reader to these resultsets. SQL_NEXT_RESULT_SET iterates through the resultsets in order when multiple resultsets are returned. SQL_NEXT_RESULT_SET returns 0 (FALSE) if there are no more resultsets and a nonzero value (TRUE) otherwise. Stored [...]

Working with new SQL Server 2008 data types

Riaz Merchant — Wed, 26 Oct 2011 13:07:00 +0000

DataFlex only supports five physical data types: NUMERIC, ASCII, DATE, TEXT and BINARY. The sixth, OVERLAP, is a logical type which maps to any one of the physical types. In the SQL world however, there are many different data types that the driver has to support. This is especially important when you are connecting [...]

New Feature: Lazy Open Mode

kristenb — Tue, 20 Sep 2011 22:33:25 +0000

Mertech’s new Lazy Open mode feature is designed to improve an application’s initialization performance by deferring table setup. Lazy Open mode delays the setup of table metadata (table, columns, indexes description) in memory until a field is accessed, even if an OPEN command is issued. Lazy Open mode is particularly useful for applications that open a [...]