Kbase P119549: Unable to query data without using TRIM function if table was created using Generate Delta.SQL utili
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
MS SQL DataServer
Windows
SYMPTOM(s):
Using the "Generate delta.sql Progress to MSS" utility to update Progress Schema Holder database and foreign MS SQL database
Resulting .DF file is successfully loaded into Schema Holder database
Resulting .SQL file is successfully loaded into foreign MS SQL database
No data is returned when searching for a specific record
Queries using WHERE clauses return no data, for example:
FOR EACH <table> WHERE <field> = "001":
No errors are generated
General queries return data as expected, for example:
FOR EACH <table>:
Data is returned if the TRIM function is applied to the field used in the WHERE clause, for example:
FOR EACH <table> WHERE TRIM(<field>) = "001":
CAUSE:
Bug# 20061005-003
CAUSE:
The .DF file generated by the "Generate delta.sql Progress to MSS" utility is missing the DSRVR-PRECISION for each field in the table
FIX:
Option #1
Upgrade to OpenEdge 10.1B
Option #2
1) Using the "Generate delta.sql Progress to MSS" utility to create .DF and .SQL files
2) Load the .SQL file into the MS SQL database to create the table there
3) Run the Update/Add Table Definitions utility to add the new table to the Schema Holder
Option #3
Use the TRIM function on the field used in the WHERE clause of the query