edit or delete with doa

[juna22]

Hello,
I am using DOA components. I receive this error:Record not found or used by another user, when I edit or delete a record. Do you happen to know why?
THNX

[Andrey]

Hello.

Thank you for contacting DelphiOCI Discussion Forum.

For quicker investigation could you please provide example of code you use in your application?

Thanks.

Andrey Romanchenko.

[juna22]

***************************************************************************************
This is the code I use to selete an equipment where ClientDataSet is connected to a DataSetProvider which linked to a OracleDataSet.
****************************************************************************************

  Datamodule1.ClientDataSet_equip.Close;
  
   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);
    datamodule1.ClientDataSet_equip.Refresh;

[juna22]

Can anyone please help me solve this error message, because I can't find the problem, the queries and eveything else seem ok.

[Andrey]

Can you Debug DelphiOCI sources?
If yes, please let me know the place (function or so) where exception has occurred.

Thanks.

[juna22]

the function sent previously is the one tha causes the error.thanks in advance

[Andrey]

New version 1.21 of DOCI is released.
There were fixes are in area you have an error.

Please, check if you still have this problem.