Using Oracle XE 10g Client

[fa icon="calendar'] Mar 16, 2008 5:38:00 PM / by Mertech Data Systems, Inc. posted in Databases

Oracle 10g XE Client is different from the client that XE server install for you, first of all with XE Client we don't get the same configurations files that we get in a XE server. No tnsnames.ora, you need to use another notation to connect to a remote server also the windows registry keys are stored in another Windows registry directory.

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

Increase Performance Using Set_SQL_Constraint from a Large Table

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

Assuming you are using a SQL database and a Flex2SQL driver, the Flex2SQL driver has a feature, SQL_Set_Constraint, that automatically adds a constraint to find all operations.

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

Open Tables Directly

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

You can open an SQL table without having an INT file by using the Open method. Although you don’t need the INT file, an FD file is still required to compile your DF/VDF application.

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

Using ACTIVATE TIME STAMP

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

You must change the FD (field definition) files and insert the macro command.

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

Running Flex2SQL for Oracle in a HP-UX

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

To run Flex2SQL for Oracle in a HP-UX,  set the environment variables below:

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

Rights for an Oracle User to Migrate With Flex2SQL

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

These are three user rights an Oracle user needs in order to migrate data with the Flex2SQL migration tool.

They are as follows:

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

Preserving Recnum During Migration

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

The Use Regular Save During Migration (SQL Server only) means that when it is checked, SQL puts recnum in sequence on backend which meaning they won't match the sequence from DataFlex. If the option is on, then the recnum will follow the DataFlex sequence on the backend. When this option is on, the migration takes longer.

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

How to Obtain Flex2SQL Driver Licensing Information From sql_drv.cfg

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

Is accessing Flex2SQL Driver registration information registered on their server, is there any program that can check the liceseing information (such as Licened To:, Number of users:, etc) from the file SQL_DRV.CFG possible?

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

Using the Restructuring Source Code Generated by Flex2SQL in VDF

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

Flex2SQL will auto generate these files:

  1. mdsrestruct.src (Its the file you will compile using your VDF compiler)

  2. MdsRestructureHelper.pkg (This package contains helper functions for restructuring your databases when using the mertech drivers)

  3. <YourTable>.inc (It has the procedure with the restructure code)
Read More [fa icon="long-arrow-right"]

How to use Triggers in With Flex2SQL Drivers

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

The following is a simple program which inserts records on ITEM table and the HEADER.TOTAL field is updated automatically:


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

Subscribe to Email Updates