Kbase P61776: All data not being inserted into database using odbc connect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/01/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Using Fedex ClipperShip/TracerX application
Pulling data from ClipperShip via ODBC
Inserting data into Progress DB through TracerX using ODBC
Random data not being loaded into database
No errors reported back to application or screen
CAUSE:
The application was not properly handling character data being added or updated in the Progress database. Some character data contained single quotes and these single quotes caused SQL errors which the application was not catching.
FIX:
Modify the application code to convert any single quotes in a character string to two (2) single quotes