I am trying to generate a report against a pervasive database. In order to get correct values from the database I need to run the ANSI_PADDING = OFF; command on the connection before the queries are run. Is there a way to run this command on a connection that all subsequent commands will use?
Date
Votes
4 comments
-
Jet Reports Historic Posts You can't directly set a value on the connection. However, I believe you could use the "Trim trailing spaces from text fields" option on the Advanced page of the data source settings. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts That setting is grayed out for me. This is using a universal connector, that may be the reason why. I have tried manually appending the space character, CHAR(32) to the end of the value that is being filtered by, but that doesn't work either. I should be appending CHAR(0) to the end of the filter value but excel doesn't recognize that.
-
Jet Reports Historic Posts Hmmm, trim is only for universal connectors. Looking at the code, it seems that trim is not supported for FoxPro, Access, or ODBC providers. I'm guessing in this case you're using an ODBC provider. A quick search online shows that Pervasive does have an OLE DB provider, at least for some versions of Pervasive. So if you switched to the OLE DB provider for Pervasive, I think you would be able to use trim. Does that help?
Regards,
HUghes -
Jet Reports Historic Posts Possibly, I will look into it.
Please sign in to leave a comment.