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?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 16 November 2023 15:12 PM UTC
  2. InfoMaker
  3. # 1

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.
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.
Hasan Haider Accepted Answer Pending Moderation
  1. Wednesday, 22 November 2023 08:12 AM UTC
  2. InfoMaker
  3. # 3

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.