problem with updates

[KhazadDoom]

May I ask you something? I start to use DOA, if I use OracleDataSet
components I have no problem with update records.
If I use Client Data Set on client side, connected with Dataset
Provider on OracleDataSet on server side I cant update records with :

Clientdataset.ApplyUpdates(0);

I have changes on clientdateset but no changes on database.

 

[Marco Kalter]

It's difficult to say what could be wrong. You can use the Oracle Monitor to see what statements are executed though. Maybe this provides a clue.

 

[KhazadDoom]

if I put OracleSession and OracleDataSet on form with sql : 'select g.rowid,g.* from tablename g' and Close, Open,First, Edit
After Edit OracleDataSet.UpdateRecord works but...

if I put SoccetConnection and ClientDataSet which is connected on server side with same query I can get updates in client side, but never went on server side.

If I use ADO on server side, everything works.

 

[Marco Kalter]

Did you try the Oracle Monitor as suggested? You can also check out the 3Tier demo project.

 

[KhazadDoom]

update "ITIROBMAT"."GRUSER" set
"POD" = :V0,
"ORG" = :V1,
"VRIJEME" = :V2
where
"KORISNIK" = :V3

problem is with field 'korisnik', char length 8, if that field contain 8 chars all is correct, but if field is shorter, update will not be made, problem with right trim of variable :v3 in this case.
Field korisnik is a primary key.

 

[Marco Kalter]

I see, you are using CHAR(8) key fields. What happens if you disable TOracleSession.Preferences.TrimStringFields?

 

[KhazadDoom]

thanks, it works with that