record not found

[juna]

I get this error message when trying to edit or delete a record:"Record not found or changed by another user".
Can you please help?
THNX

 

[Marco Kalter]

Are you using a ClientDataSet / DataSetProvider?

 

[juna]

Yes, I am using both of them.

 

[Marco Kalter]

Is TDataSetProvider.ResolveToDataSet enabled? If so, does it help if you disable it?

 

[juna]

TDataSetProvider.ResolveToDataSet is disabled while I get the same error message.

 

[Marco Kalter]

Can you set TOracleDataSet.Debug to True to verify which statement is executed that leads to this "Record not found or changed by another user" conclusion by the TClientDataSet?

 

[juna]

I did it but still I don't know what causes the error because the queries seem to work well.

 

[Marco Kalter]

Okay. Can you post the SQL of the dataset?

 

[juna]

datamodule1.ClientDataSet_equip.Close;
/* it gets the id of the equipment to be deleted*/
equipment_id:= DataModule1.ClientDataSet_equip_all.Fields.FieldByName('Equipment_id').Value;

DataModule1.ClientDataSet_equip.CommandText :=('select a.* from equipment a,equipment_category b, equipment_status c, manufacturer d, equipment_type e');
DataModule1.ClientDataSet_equip.CommandText := DataModule1.ClientDataSet_equip.CommandText + (' where a.equipment_category_id = b.equipment_category_id and a.status_id =c.status_id and a.manufacturer_id =d.manufacturer_id and a.equipment_type_id = e.equipment_type_id and a.equipment_id =:equip_id');
DataModule1.ClientDataSet_equip.Params[0].Value := equipment_id;

datamodule1.ClientDataSet_equip.Open;
datamodule1.ClientDataSet_equip.Delete;
datamodule1.ClientDataSet_equip.ApplyUpdates(-1);

 

[juna]

Also this error does not occur every time I do a delete or edit.Maybe this wil help find the problem

 

[juna]

I desperately need to solve this error can anyone help?

 

[phoenix610]

it seems ur issue has a relation to string trimming. the table which u want to update or somthing have char or varchar2 colums, doesnt it??

if so, refer
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=002304
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=002059

if not so, i have no clue but all u have to do is
checking what sql is thrown to the oracle sever
by using OracleMonitor or setting TOracleDataSet.Debug to True.

 

[juna]

Thank you, the issue had to do with string trimming