ZeosDbo TZUpdate error operation is not allow for closed Dataset

[eldonfsr]

Hi friend some body can help me i don't know why i have query with sql from table but when i update the table or query send me error Operation is not allow for closet DataSet, Table is open query is open...
just on Post method...

this in ZUpdatePo ModifySql
UPDATE PO1_PurchaseOrderEntryHeader SET
PurchaseOrderDate = :PurchaseOrderDate ,
OrderType = :OrderType ,
MasterRepeatingPOOrSO= :MasterRepeatingPOOrSO,
Division=:Division
WHERE PurchaseOrderNumber = :PurchaseOrderNumber
AND DIVISION =:DIVISION

Code: Pascal  [Select][+][-]

1.     with ZUpdatePo.Params do begin
2.        ZUpdatePo.Params.ParamByName('PurchaseOrderDate').AsString:='``{d''2024-03-07''}``';
3.        ZUpdatePo.Params.ParamByName('OrderType').AsString:='S';
4.        ZUpdatePo.Params.ParamByName('MasterRepeatingPOOrSO').AsString:='O-S';
5.        ZUpdatePo.Params.ParamByName('PurchaseOrderNumber').AsString:='A39173      ';
6.        ZUpdatePo.Params.ParamByName('DIVISION').AsString:='02';
7.      end;
8.     ZQBrwPo.Edit;
9.     ZQBrwPo.Post;
10.     Try
11.       ZQBrwPo.ApplyUpdates;
12.     except
13.       ZQBrwPo.CancelUpdates;
14.       ShowMessage('Not  update purchase order.');
15.     end;
16.     ZQBrwPo.Refresh;
17.  

 

[Soner]

First check if the connection is active, then do this:

Code: Pascal  [Select][+][-]

1.    if not ZUpdatePo.Connection.Active  then ShowMessage('Connection not active!'); //for test
2.    ZUpdatePo.Active:=false;  // <-- !
3.     with ZUpdatePo.Params do begin
4.        ZUpdatePo.Params.ParamByName('PurchaseOrderDate').AsString:='``{d''2024-03-07''}``';
5.        // ... and other params...
6.      end;
7.     Try
8.      ZQBrwPo.ExecSql; //<-- !
9.      ZQBrwPo.ApplyUpdates;
10.     except
11.       ZQBrwPo.CancelUpdates;
12.       ShowMessage('Not  update purchase order.');
13.     end;
14.     ZQBrwPo.Refresh;
15.  
16.  

[eldonfsr]

Thanks so much great tip....

[Soner]

Yesterday I forgot to tell you that you only need edit/post with data-controls and your query must be active before calling edit/post.
Without data-controls TZQuery.ExecSql for edit/insert data and TZQuery.Open or "TZQuery.Active:=true;"  for "select" querries.

[eldonfsr]

Soner what version of zeos you are using, because i have 8.0 but don't show up property connection on TzUpdatde, could be on previous version.... i don't use seoz before is my first time working with zeos...

and examples look simples but when run test some changes was made and don't run...

Thanks for you comments and help..
 

[Soner]

Sorry it is my fault, it should be:

Code: Pascal  [Select][+][-]

1. if not ZQBrwPo.Connection.Active  then ShowMessage('Connection not active!'); //for test
2.  

I'm still using version 7.2.4-stable.