1. Antonio Arena
  2. PowerBuilder
  3. Thursday, 21 October 2021 09:34 AM UTC

Hi All,

we are migrating to PB2021 our WebServices that we developed with PB2017 R3 and we are facing the following problem:

all the lds_DataStore.Retrieve() calls return -1 in PB2021. If we try to get the SQL statement of the DataObject with lds_DataStore.Describe("datawindow.table.select") the return value is a string of apparently randm characters and not the real SQL statement.

It seems that the SQL part of the DataObject is lost or modified.

Did someone have the same problem? Can anyone suggest a solution?

Thank you in advance for your replies.

 

Antonio

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 21 October 2021 13:55 PM UTC
  2. PowerBuilder
  3. # 1

Hi Antonio;

  In a PS 2021 deployed application, the real SQL in the client has been morphed into PS web services. It's now the PS WS that runs the real SQL and the client DW/DS objects are just left with Restful Web API calls.

Regards.. Chris

Comment
There are no comments made yet.
Antonio Arena Accepted Answer Pending Moderation
  1. Thursday, 21 October 2021 14:21 PM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

thank you for your reply.

Actually, we are using PowerBuilder and not PowerServer. We deploy our WebService using the MSI file that the .NET WebService Target generates.

The DW syntax is modified in the following way: retrieve="cloud;MTYzNDc2MzMzMA==;uLQgX4swwIkYIwm0mRYMpk9f8D7WoLAyOjocX67cWldoGWsombadlVFBF/fEQmOAzWIaaqFGhOEvqtNmy8eCG++koJXXcIFG8UuqZg7wRluRAkT42F4joTT1Uzwl7B94NhX5twTaSNOcguklR1/dBafkLml1gC78+5mi9WVOCRw=" 

I guess if there is a way to avoid the SQL statement of the DW to be modified.

Thank you

 

Antonio

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 21 October 2021 15:37 PM UTC
Q: I guess if there is a way to avoid the SQL statement of the DW to be modified.

A: No, PowerScript always has full control.
  1. Helpful
There are no comments made yet.
ayman ahmad Accepted Answer Pending Moderation
  1. Tuesday, 7 June 2022 21:15 PM UTC
  2. PowerBuilder
  3. # 3

is there any solution for this problem ?

Comment
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.