1. Ivan Aase
  2. PowerServer
  3. Friday, 24 February 2023 12:08 PM UTC

Hi.

When running powerserver 2022 with dynamic cursor and DynamicDescriptionArea we are getting different answer on output paramtype in powerserver regards to standard Client Powerbuilder

Standard Client return TypeLong! in OutParmType[1] while Powerserver return TypeString! 

same code and same type of data and run.

Anyone that could explain why ?

	DynamicStagingArea dsa_sql
	DynamicDescriptionArea dda_sql
	
	Declare cur_sql_halvtrans Dynamic Cursor For dsa_sql;
	
	// Prepare 
	Prepare dsa_sql From 'select i_adr_number from hf.adressehistorikk where i_id = 334' Using this;
	Describe dsa_sql Into dda_sql;
	
	For l_peker = 1 To Upperbound( pan_parameters[] )
		SetDynamicParm( dda_sql, l_peker, pan_parameters[l_peker] )
	Next
	
	Open Dynamic cur_sql_halvtrans Using Descriptor dda_sql;
	
	l_peker = 0
	
	Fetch cur_sql_halvtrans Using Descriptor dda_sql;
	Do While this.sqlcode = 0
		l_peker ++
		Choose Case dda_sql.OutParmType[1]
			Case TypeDecimal!, TypeDouble!, TypeInteger!, TypeLong!, TypeReal!, TypeUint!, TypeUlong!, TypeBoolean!
            pan_result[l_peker] = GetDynamicNumber( dda_sql, 1 )
			Case TypeString!
            pan_result[l_peker] = GetDynamicString( dda_sql, 1 )
			Case TypeDate!
            pan_result[l_peker] = GetDynamicDate( dda_sql, 1 )
			Case TypeDateTime!
            pan_result[l_peker] = GetDynamicDateTime( dda_sql, 1 )
			Case TypeTime!
            pan_result[l_peker] = GetDynamicTime( dda_sql, 1 )
			Case Else
				guo_lasterror.f_raiseerror( 0, this, "", "uo_halv_transaction.f_cursorsql( ) : Dynamisk cursor : GetDynamic returns invalid type.~r~n~r~n" + helpers.novalue( ps_tilleggsmelding, "N/A" ) + "~r~n~r~nDYN. SQL:~r~n" + helpers.novalue( ps_sql, "N/A" ) )
		End Choose

		Fetch cur_sql_halvtrans Using Descriptor dda_sql;
	Loop
	
	Close cur_sql_halvtrans;

	Destroy dsa_sql
	Destroy dda_sql

uploaded codeexample.

 

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 24 February 2023 17:51 PM UTC
  2. PowerServer
  3. # 1

What database are you using?

Comment
  1. Ivan Aase
  2. Friday, 24 February 2023 23:24 PM UTC
hi,

Using : Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Thursday, 2 March 2023 15:56 PM UTC
Hi Ivan, As Mark mentioned, this is a bug and our development team will fix it. We do not yet have clear schedule when it will be fixed, so I suggest you open support ticket so team can properly track this issue and notify you when fix available. Also, if you urgently need to deploy your project to users, maybe our support team can suggest a workaround.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 24 February 2023 14:48 PM UTC
  2. PowerServer
  3. # 2

Hi Ivan;

  I would suggest opening a Support Ticket for this issue. You may have found a new PS nuance that needs to be investigated further by our Appeon engineers.

Regards ... Chris

Comment
  1. Ivan Aase
  2. Friday, 24 February 2023 15:01 PM UTC
Thanks,I'll do that.

And look forward to either corrections or input on what I can do
  1. Helpful
  1. Mark Lee @Appeon
  2. Thursday, 2 March 2023 07:29 AM UTC
Hi Lvan,



This issue is a bug.

We reproduced it on our end and our development team will work on fixing it.

We will get back to you once it gets fixed.

  1. Helpful
  1. Mark Lee @Appeon
  2. Friday, 21 April 2023 03:36 AM UTC
Hi Ivan,



Good news that PowerBuilder 2022 MR (build 1900) is available for download.

The issue you reported has been fixed in this release.

Please download and install it to verify the issue you reported and let us know if any problems.

You can get the installer from our Downloads portal at https://account.appeon.com/download (login required).



We welcome all feedback from you!

  1. Helpful 1
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.