Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Datawindow fails update on PowerServer

  1. Issue
0
Votes
Undo
  1. Jason Frost
    Jason Frost
  2. PowerServer
  3. Thursday, 3 March 2022 00:31 AM UTC

Can anyone help with this:

I've got a PB application and on a window there is a classic header/detail layout with two datawindows.  You can update details in header and detail and when you save the data is updated using DW Update() function.

This all works fine in classic app.  However, when deployed to PowerServer the header DW updates but the detail DW doesn't.  It is the same database I'm connected to in both scenarios.  In PowerServer I just get a db error code of -1 back, no error text or anything else useful.  The DW retrieves OK and behaves normally in all other respects.

DB is Oracle if that helps at all.

I've tried various things, checked the SQL, removed table aliases, regenerated etc. etc., but nothing makes any difference.  I'm getting desperate now!

Thanks

PS 2021 updating last update user
PowerServer 20201 PB Edition
Responses (2)
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Thursday, 3 March 2022 04:58 AM UTC
  2. PowerServer
  3. # 1

Hi Jason,

Do you mean the detail DataWindow can retrieve successfully but failed to Update?

Both the value of SQLCode and SQLDBCode are "-1"?

 

Since I can't see any sample code including the DataWindow object or the Model class, it is difficult to determine the reason. It is recommended that you do some basic checks:

1. Detect unsupported features in your PB project.

E.g.: dwcontrol.SetTrans is not supported. Use SetTransObject to replace the SetTrans function.

Refer to: https://docs.appeon.com/ps2021/How_to_catch.html

2. Learn about using Fiddler to find the request and response information when updating DataWindow.

Refer to: https://docs.appeon.com/ps2021/debugging_guide.html

3. Use the SnapDevelop debugging feature to see if the SQL executed is correct.

Refer to: https://docs.appeon.com/ps2021/Debugging_log_in_SnapDevelop.html

 

You can also learn more debugging methods from: https://docs.appeon.com/ps2021/debugging_guide.html

If it still does not resolve the issue, kindly please report your issue via our support ticketing system to ensure it is being properly received by our tech support and tracked at: https://www.appeon.com/standardsupport/

 

Regards, Logan

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 3 March 2022 03:32 AM UTC
  2. PowerServer
  3. # 2

Which version of Oracle and which version and build of PB?

regards.

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 3 March 2022 04:40 AM UTC
But you can't UPDATE a VIEW.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 3 March 2022 04:41 AM UTC
Ahh .. okay, I see what you mean: You'd use a view for some inner sub-query :)
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 3 March 2022 04:42 AM UTC
Also, check the edited source code: See if you have some column with a type of "char(0)" which is not uncommon to find when dealing with UNIONs.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.