Specifications

Configuring the PlantScape ODBC Driver

PlantScape Server and Client Configuration Guide 407

The equivalent SQL query is:

SELECT "TimeStamp" ,"Value001", Quality001

FROM "History1MinSnapshot"

WHERE ( ( ("Parameter001" = ’TankLevel.pv’ ) AND

("TimeStamp" > {ts ’1997-07-25 10:00:00’} ) ) AND

("TimeStamp" < {ts ’1997-07-25 16:00:00’} ) )

Case-Sensitive Searches

By default all queries made by the PlantScape ODBC driver are case insensitive.

For some queries it might be useful to perform a case-sensitive search. If you

want to make searches case-sensitive for a particular data source, you need to

add a string to the registry. To do this:

Open a Command Prompt window and enter the command:

regedt32

Go to the registry key

HKEY_CURRENT_USER->Software->ODBC->ODBC.INI->

where:

Is the data source you configured (as described in “Configuring a Data

Source” on page 394) and wish to use to do case-sensitive searches.

Add the following new string value for that registry key.

CaseSensitive

Set the Data value to:

Troubleshooting ODBC Driver

Spurious Entries in Data Tables

Entries such as “#NAME” or “#DELETED” can appear in the tables in

Microsoft Access if you select an entry in a Unique Identifiers dialog box

after you have selected the data tables (see “Step 1. Linking Tables” on

page 408).

plscpcg.book Page 407 Monday, May 28, 2001 10:11 AM