Skip to content

Opening a Table without Using an Intermediate File

DataFlex SQL Drivers

It is possible to open a table without using an intermediate file. The general way to do this for a DataFlex SQL Driver is by using the following format:

Open "<driver>:<schema>#<table>@<connect_string>"

Where:

  • <driver> is the driver identifier (MSSQLDRV, DB2_DRV, or ODBC_DRV).
  • <schema> is the name of the table's schema or owner (optional).
  • <table> is the name of the table.
  • <connect_string> is the connection string needed to connect to the database.

Example

The connection string mentioned above can have two formats, but is always identical to what you usually specify in the table.int file. If you use Connection Ids, the following could be your situation:

Open "MSSQLDRV:dbo#customer@SERVER=DFCONNID=ORDERENTRY" as hTable

If you do not use Connection Ids, the following is the classic way of opening:

Open "MSSQLDRV:dbo#customer@SERVER=.\SQLEXPRESS;UID=DataAccess;PWD=DataFlex;DATABASE=OrderEntry" as hTable

DataFlex Pervasive.SQL Driver

When using the DataFlex Pervasive.SQL Driver in database mode, open a table without using an intermediate file by using the following format:

Open "DFBTRDRV:btrv://psqluser@MyPervasiveServer/Order?table=salesp&pwd=secret" as hTable

When using the DataFlex Pervasive.SQL Driver in non-database mode, open a table without using an intermediate file by using the following format:

Open "DFBTRDRV:<logical_name>|<physical_name>.btr" as hTable

Where:

  • <logical_name> is the table’s logical name as defined in the file.ddf meta database table.
  • <physical_name> is the table’s physical name on disk.

If you have no INT file but converted the table with Recnum support, you need to make this clear to the driver. The way to do this is to add a ‘+’ sign to the end of the base name of the table. Examples of root names that will open tables directly with Recnum support are:

MyFile+.BTR
DFBTRDRV:MyFile+

See Also