Migrating Overlap With DESCENDING Segments

[fa icon="calendar'] Feb 19, 2008 11:09:00 AM / by Mertech Data Systems, Inc. posted in DataFlex

While converting database of a file, there's a migration problem in Flex2SQL. The error seems to indicate a problem creating the inverse key for overlap field.

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

Flex2SQL Conversion Stops

[fa icon="calendar'] Feb 19, 2008 11:00:00 AM / by Mertech Data Systems, Inc. posted in DataFlex

In using Flex2SQL for record transfer, it stops without any apparent errors before completion. The problem was due to the DATE_ACQ field, more specifically the value of a leap year (for example, 2-29-1900).

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

Creating a SQL Database

[fa icon="calendar'] Feb 18, 2008 4:19:00 PM / by Mertech Data Systems, Inc. posted in Databases

Code to create a database:

String sMsg sPath
integer iDBExist iError
handle hoWorkspace
Read More [fa icon="long-arrow-right"]

Fetching Date Values into DataFlex Date Field Using Embedded SQL

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

SQL Server databases have a unique date format. This is a clean way to receive date columns from a statement (stmt) directly to a DataFlex (DF) Table.Field or a Date Variable.

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

Calling a Stored Procedure Passing and Receiving a Date

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

The DataFlex date format isn't compatible with MS SQL. You must change the way an argument is passed and/or is received.

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

Trouble Loading DLL on Linux

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

The error is generated when a driver cannot be loaded by DataFlex. There could be multiple reasons for this:

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

'Error ORA-00942' During Migration

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

This error happens when the user doesn't have DBA rights, Flex2SQL requires DBA role when converting the table, if not, then the error: "Error : ORA-00942: table or view does not exist" comes up.

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

Subscribe to Email Updates