Page 1 of 1
Error Message for Fields with spaces as Value
Posted: Wed 13 Jul 2005 20:52
by Karen
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.
Posted: Thu 14 Jul 2005 09:32
by Alex
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.
Posted: Thu 14 Jul 2005 15:37
by Karen
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.
Posted: Thu 14 Jul 2005 20:27
by Karen
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.
