1. Hasan Haider
  2. InfoMaker
  3. Thursday, 16 November 2023 06:58 AM UTC

I have built an application on powerbuilder. I want to integrate infomaker with powerbuilder so that my clients can create their own reports from the database.

Could someone guide me regarding the steps for this?

Hasan Haider Accepted Answer Pending Moderation
  1. Wednesday, 22 November 2023 08:12 AM UTC
  2. InfoMaker
  3. # 1

Hello,

Thank you for all the help. 

I did the following steps and I am getting an error. Please let me know what went wrong and how to fix this.

1. I created a library (.pbl) in my application in powerbuilder.

2. I created a vc and a datawindow control with a generic (employee table) query.

3. I Added the library in Infomaker. (Now I am able to access the same datawindow from powerbuilder as well as infomaker).

4. I changed the query for this datawindow via infomaker (this is basically what I want the user to do eventually).

5. When I ran the powerbuilder app after saving this changed query and tried to access the grid (datawindow), it gave an error saying incorrect syntax

Cause of Error:

In powerbuilder, when I went to check the datawindow query (which should have been changed now due to infomaker change), It shows the following line instead of the changed query:

"cloud;MTcwMDYzOTQ4NQ==;3lLts6zGi1oMR9IN1KPJe4W1yLVU39BEP5z/uoPFXdM2DSfmxhBX3UoCg0SpHa/rp9ZqUyVmdcCfh7dFSYp68w=="

This causes the error.

How do I fix this? 

Comment
  1. Hasan Haider
  2. Thursday, 23 November 2023 04:52 AM UTC
No. Thank you for pointing this out. I am using the following:

1. Powerbuilder 2019 R3

2. Infomaker 2022 R2
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 23 November 2023 05:14 AM UTC
Yes, PB 2019 will probably not understand an IM 2022 report (DataWindow) source.
  1. Helpful 1
  1. Hasan Haider
  2. Thursday, 23 November 2023 05:17 AM UTC
thanks. lemme switch to PB 2022 and test this out.
  1. Helpful 1
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 16 November 2023 17:39 PM UTC
  2. InfoMaker
  3. # 2

Hi, Hassan - 

To add to what Chris has said, you might want to look at the GetLibraryList, SetLibraryList, and/or AddToLibraryList PowerScript functions. These methods can be used to dynamically change the application's list of PBD's at execution type. Your app could "attach" a user's individual IM library, and/or an IM library shared by a team, department, or other organizational group, etc.

Best regards, John

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 November 2023 15:12 PM UTC
  2. InfoMaker
  3. # 3

Hi Hassan;

  It's pretty straight forward as IM is technically basically PB "under the hood" - just with a different look & feel to the same IDE.

  So the PBL library in IM is the same as PB. All you need to do is have a shared PBL between IM and your PB IDE / PB App and they can access the same reports back & forth as an IM report is really just a DataWindow. The only main consideration is to make sure that you keep the PB & IM releases at the same version & build so that the Report / DWO's are technically the same source / runtime code (as this is a dependency).

HTH

Regards ... Chris

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