Problems with DOA dataset...

[The Avatar]

We are working with Delphi 2005 against a Oracle Express 10g Database using DOA components ( we use a session+dataset+datasource, we create dataset in runtime ).
We got troubles making writting operations with DOAdataset,it gave us a message error saying that it was in 'readonly' mode. We fixed this error adding the field 'Rowid' to the Select in the SQL.
Since then, when we make an insertion with an Append and Post commands, the data from a field is stored in the previous field.
Example:
COD-NAME-STREET-PHONE
When we append and post this dates:
1-John-Parker Street-626458789
This is the resultant stored information:
1-John-626458789-'NULL'
May you help us with this?
Thanks.

 

[The Avatar]

We are evaluating DOA components in order to buy and use them in our application. Of course, if we cannot make them work properly we

 

[Marco Kalter]

See this topic for a solution.

 

[The Avatar]

That topic doesn

 

[JEK]

I already had this same problem, its an Oracle Express bug.
I've followed the instructions of this topic to get it working fine.
Hope it works for you too.

 

[The Avatar]

How do we change the NLS-Setting to set our client charset the same as the server??
May you help us?
Thanks ^^

 

[The Avatar]

We have fixed the problem changing the session option 'bytespercharacter' value to 'autodetect'.
Thanks!! ^^