Appeon Comunidad

Preguntas y Respuestas Comunidad de Appeon

1. DataWindow returning -1 without running Select statement

   We're experiencing an issue with a legacy powerbuilder application and could use some advice on how to proceed. 

   We recently switched build servers where this application is built, and the application behaves differently based on which build server is used. 

   When built on the old build server, the application works as expected. 

   When built on the new build server, the application throws an error. 

   We have troubleshot the problem down to one datawindow that, when the Retrieve method is run on in it, returns a -1. We added code to capture the sqlerrtext and sqldbcode right after the Retrieve, and they are an empty string and 0. We also used a packet sniffer to determine that no Select statement is sent over to the database during this Retrieve. 

   So we have a datawindow that fails with a -1 without attempting to run a Select statement. This Datawindow and its embedded Select statement has worked as is in the past, and in fact continues to do so when we build the application on the old build server. 

   So, two questions:

   Is there any techniques for trying to determine why the Datawindow is returning a -1?

   What should we look for for differences between the two build servers? They both are using

       PowerGen® Version 12.5.03 for PowerBuilder® V 2021
       PowerBuilder ORCA Version: 21.0.0.1509

2. Any guidance to write entries in pbodb.ini for SQLite

   Hello,

   Using PB 2022 R3 with SQLite 3

   When we retrieve data in a datawindow from SQLite database, all (numeric) computed columns are retrieved as character fields.  And converting the character values into numeric and then doing the required computation takes time.  Otherwise, the performance of the query is really fast (tested with limited data, as we plan to use for that level of data only).  I think, if datawindow could transfer those numeric values as numeric values, I feel that the performance will be much better.  

   And in one of my threads, Roland has recommended to write entries in pbodb.ini file.  I don't have any experience in that.  Can someone give me idea how to write entries in that file.  say should I start with 

   [SQLite]      OR
   [SQLite 3]   OR
   [SQLite 3.2] OR
   something else...

   How to check whether that entries are being taken by Powerbuilder / Datawindow ?

   Any idea / guidance is really appreciated.

   Happiness Always
   BKR Sivaprakash

    

3. SetText doesn't change state in checkbox editcontrol

   Hi 

   I try to check / uncheck datawindow checkbox editcontrol from program. 

   When I change the value with SetText() the datavalue changes but it doesn't effect the checkbox state.

   Hope for help.

   BR Jesper 

4. Can we connect to different servers through configuring wsnaddr in ini file ?

   Hello ,

   I am using PowerBuilder 2019 R3 and tuxedo is a middleware to connect with backend .

   My question is that Can we connect to different securities suppose 1 security is down  can i connect to second security by configuring something in ini files.

   Currently I am configure one WSNADDR in my ini and its working fine but suppose that security is down how can we connect to different security automatically ?

    

5. PB 2022 R3 -->Consume .Net dll in PB

   Hi,

   Am using PB 2022 R3, planning to consume .NET dll using OLE Object in PB,
   .NET dll is created  and build using .net 6 core (VS 2022) - Is it possible to consume it in PB?,

   while consuming i am getting dll cannot be created.

   Note: I have already consumed .NET dll in PB successfully (which was created using Target Framework 4.5 (VS2019)).

   Thanks,
   Tharani