Error Message for Fields with spaces as Value

Karen · Post by **Karen** » Wed 13 Jul 2005 20:52

We are converting application from BDE to ODAC with Delphi 2005. If the fields have spaces(' ') as value. It gives error "field must have value" for NOT NULL fields while using TOraQuery component. The same application works fine for BDE under delphi 2005. Any suggestion.

Alex · Post by **Alex** » Thu 14 Jul 2005 09:32

Sorry, we cannot reproduce your problem. Please specify your ODAC version, Oracle client/server version. If it is possible, try to reproduce your problem on small project and send this project (including serverside object s creation script) to us. Send message to ODAC support address.

Karen · Post by **Karen** » Thu 14 Jul 2005 15:37

We are using ODAC 5.55.0.20 for Delhi 9. Oracle Server:8.1.5.0.0. We noticed this problem with fields with CHAR as field type. I will try to send demo project ASAP.

Karen · Post by **Karen** » Thu 14 Jul 2005 20:27

Found the problem, it is with TrimFixedChar property of ToraQuery , Everything works fine if we change property to False.
Our application is replicating data between oracle 9 server and personal oracle 8. The problem we had was when we save data from server to client dataset, it trimmed all fields which has spaces as value. And then we move data from clientdataset to personal oracle, it gave error that Field should have value.