[Progress Communities] [Progress OpenEdge ABL] When using the startup parameter -SQLWidthUpdate set to ON automatically set -SQLTruncateTooLarge to OU

  • Thread starter Thread starter BrendaForshee
  • Start date Start date
Status
Not open for further replies.
B

BrendaForshee

Guest
We set SQLWidthUpdate to ON without setting SQLTrncateTooLarge to anything. The default is ON which caused a lot of our queries to return bad data like duplciate records, and not all the records. It took a long time to realize that SQLWidthUpdate set to ON was not playing nice with the SQLTruncateTooLarge default of ON. The following works: -SQLWidthUpdate ON -SQLTruncateTooLarge OUTPUT But without adding on -SQLTruncateTooLarge OUTPUT, we get inconsistent results with our queries.

Continue reading...
 
Status
Not open for further replies.
Back
Top