1. Lemuel Bacli
  2. PowerBuilder
  3. Friday, 17 July 2020 04:39 AM UTC

Hi,

 

Im still in the process of testing the powerbuilder app I recently migrated to web platform. I have this data window report that accepts 5 retrieval argument as specified with the Stored Procedure, but when i try the same report in the web platform it prompts Expecting 7 arguments but got 5. Im passing the arguments using structure

I've tried the same report on the desktop version and the report goes well.

So my question is, is there a way to trap what variable is not supplied with value? Does the web conversion alters the way of retrieval?

 

Thanks!

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 17 July 2020 15:08 PM UTC
  2. PowerBuilder
  3. # 1

Hi Lemuel;

   Is the SP being called by:

  1. In-Line SQL
  2. SP based DW object
  3. API call via the Transaction Object

  Also, can you tell us ...

  • PB version & build
  • PS version & build
  • DBMS version & build
  • DB Client used to connect to the DBMS

Regards ... Chris

Comment
There are no comments made yet.
Lemuel Bacli Accepted Answer Pending Moderation
  1. Monday, 20 July 2020 09:35 AM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

 

The Stored procedure is called via DW Object. 

 

The procedure has only 5 arguments,  the values are set properly. That's why im confused why it was prompting that it needs 7 arguments but only 5 supplied while it works properly on desktop version of the application.

 

As for the information you needed:

Im using,

 

PowerBuilder 2019 - Universal Edition Build 2082

PowerServer (PB Edition) 2019 Build 2170.00

MSSQL 2016

MS SQLNCLI (?) im not sure if this is what you need. 

 

 

Thanks!

 

Comment
  1. Chris Pollach @Appeon
  2. Monday, 20 July 2020 16:17 PM UTC
Hi Lemuel;

The SP based DWO should work the same in PS vs a native PB App.

Is your PowerServer "Data Source" set to using the "MS SQL Server Native Driver and your App's transaction Object mapped to that?

Regards ... Chris
  1. Helpful
  1. Lemuel Bacli
  2. Friday, 24 July 2020 03:07 AM UTC
HI Chris,



I have replied using the response so that i could attached a photo.



thanks :)
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 24 July 2020 14:07 PM UTC
Thanks .. that driver looks great for SS. I would suggest at this point opening a Support Ticket and attaching your PS's LOG file(s) to the ticket for further & deeper analysis.
  1. Helpful
There are no comments made yet.
Lemuel Bacli Accepted Answer Pending Moderation
  1. Friday, 24 July 2020 03:06 AM UTC
  2. PowerBuilder
  3. # 3

Yes Chris!

 

I have attached a photo of my data source configurations. 

 

Im using the BMS datasource 

Attachments (1)
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.