Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (6)

Resolved SQL Server Examples Database

  1. How-to
0
Votes
Undo
  1. Jim Nesbitt
    Jim Nesbitt
  2. PowerBuilder
  3. Monday, 6 February 2023 11:47 AM UTC

Hello

We use SQL server, DB. I installed Powerbuilder 2022,  but there was some glitch during installation and the example database was not installed. 

I want to run the Google Charts demo locally against a SQL Server DB.

Is a sample database for SQL Server available anywhere that I could download? I found Postgresql and SQL anywhere on GitHub, but couldn't find one for SQL Server.

Thanks

Jim

 

  1. PowerBuilder (Appeon)
  2. SQL Server
Issue with linked server view creating datawindow
Send data to Cloud
Accepted Answer
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 6 February 2023 12:24 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi,

I don't think there is one available to sql server. Also keep in mind that sql and datawindows might have a slightly different syntax in the demo for sql anywhere and the one for postgresql.

regards.

 

Comment
Jim Nesbitt
  1. Jim Nesbitt
  2. Monday, 6 February 2023 16:50 PM UTC
Hi Miguel



I downloaded Progresql and managed to set up the DB + ODBC connection so I could run locally. It might have been problematic with SQL server as it uses ODBC,



Thanks



Jim

  1. Helpful 1
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Monday, 6 February 2023 17:27 PM UTC
yw, that's great!
  1. Helpful
There are no comments made yet.
Responses (6)
Jim Nesbitt
Jim Nesbitt Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 18:55 PM UTC
  2. PowerBuilder
  3. # 1

I saw the comment from Mora, but it didn't fully sink in.

In most of our datawindows, we generally only have simple selects from a view. This allows us to minimise changes to the datawindow as the view can be reconfigured without changing the datawindow plus it shrouds any complexity. 

This isn't causing me any problems, plus I'm very impressed with the responsive from Q&A - it's excellent.

Kind Regards

Jim

 

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 9 February 2023 11:15 AM UTC
They're the BEST!
  1. Helpful 1
There are no comments made yet.
Jim Nesbitt
Jim Nesbitt Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 15:52 PM UTC
  2. PowerBuilder
  3. # 2

Hello Mora

I spoke too soon. There are 3 datawindows that use to_char which is not valid in SQL server and the ODBC driver is returning an error. They are using datawindow syntax rather than PBSELECT to get details. d_ldline uses limit which is also invalid. 

d_ldline

d_scatter

d_timelines

I'll just switch back to using progresql until this is resolved. 

Jim

 

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 8 February 2023 17:59 PM UTC
(In addition, due to special reasons, the SQL Server corresponding Demo source code will be provided later, and we will inform you then.)
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 8 February 2023 18:28 PM UTC
Good catch... I missed that last sentence and assumed that the app was supporting SQL Server. So seems either need to manually resolve those problematic DataWindows or wait for the updated demo app to be released.
  1. Helpful 1
Mora Wang @Appeon
  1. Mora Wang @Appeon
  2. Thursday, 9 February 2023 09:44 AM UTC
Hi Jim,



According to the problem you described, I have checked the Demo source code of PostgreSql, SQL anywhere and SQLServer. Only the PostgreSql Demo source code contains the d_kdline, d_scatter and d_timelines objects which use to_char in the datasource syntax, so you’re probably using the PostgreSql db Demo source code (Note: If it is a new installation of PB, there will be a DB type selection interface during the installation process, and the installation package will release the accompanying Demo source code according to the selected DB type; If it is MR Upgrade, the installation will continue to use the Demo DB type selected for the existing version and release the supporting Demo Code). The source code of PostGresql cannot be used together with SQL Server Demo db.

I will let you know once the SQL Server Demo source code is uploaded so that you can download and use it.



Thanks & Regards,

Mora
  1. Helpful 1
There are no comments made yet.
Jim Nesbitt
Jim Nesbitt Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 12:30 PM UTC
  2. PowerBuilder
  3. # 3

Hi Mora

That was fast!  SQL server demo db is downloaded and running fine with Charts example now. 

Thanks

Jim

Comment
Mora Wang @Appeon
  1. Mora Wang @Appeon
  2. Thursday, 9 February 2023 09:43 AM UTC
Hi Jim，



That's great!

You're welcome, glad to help you, ∩_∩



Regards,

Mora
  1. Helpful
There are no comments made yet.
Mora Wang @Appeon
Mora Wang @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 08:29 AM UTC
  2. PowerBuilder
  3. # 4

Hi Jim & Miguel,

 

The download link for SQLServer Demo DB is as follows: https://github.com/Appeon/PowerBuilder-Project-Example-Database.

Open the link > click pbdemodb_for_sqlserver.zip to download the Database.

There are Steps to restore pbdemodb_for_sqlserver at the bottom of the page for your reference!

 

In addition, due to special reasons, the SQL Server corresponding Demo source code will be provided later, and we will inform you then.

 

Thanks & Regards,
Mora

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 8 February 2023 10:26 AM UTC
Thank you Mora,

BTW: it was in the interest of Jim Nesbitt, who asked the question, but still good to know!

regards.
  1. Helpful
Mora Wang @Appeon
  1. Mora Wang @Appeon
  2. Thursday, 9 February 2023 09:42 AM UTC
Hi Miguel,



Thank you for reminding ，∩_∩



Thanks & Regards,

Mora
  1. Helpful
There are no comments made yet.
Mora Wang @Appeon
Mora Wang @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 7 February 2023 10:08 AM UTC
  2. PowerBuilder
  3. # 5

Hi Jim & Miguel，

Thanks for using Powerbuilder 2022.
We are making supporting preparations, and will provide you with corresponding download links and instructions for connection reference after completion.

Thanks & Regards,
Mora

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 7 February 2023 12:21 PM UTC
Hi Mora, that's good news!
  1. Helpful
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.