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

Resolved SQL create scripts for EZ Order

  1. Issue
0
Votes
Undo
  1. Jeff Hamilton
    Jeff Hamilton
  2. PowerBuilder
  3. Friday, 18 March 2022 17:43 PM UTC

I am following the PB Tutortials for PB 2017. I am having a problem running the applications cause it does not have the database for the examples. I do not want to use the SQL Anywhere and would like to get the scripts to create the tables and supporting objects in a different format. Does anyone know where I can get these SQL scripts?

To get IP address (from ISP) from PB application
The "IsNull()" function is not working
Responses (4)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 18 March 2022 18:10 PM UTC
  2. PowerBuilder
  3. # 1

The database file should be here:

C:\Users\Public\Documents\Appeon\PowerBuilder 17.0

 

Comment
There are no comments made yet.
Jeff Hamilton
Jeff Hamilton Accepted Answer Pending Moderation
  1. Friday, 18 March 2022 18:35 PM UTC
  2. PowerBuilder
  3. # 2

Checked the folder and no database or scripts.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 18 March 2022 20:50 PM UTC
Hi Jeff ... that means that you probably opted out of installing the sample & example applications. Thus the PB DEMO DB for PB20217 was not installed either. Reinstalling PB2017R3 & choosing those optional Apps will get you the DemoDB.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Jeff Hamilton
Jeff Hamilton Accepted Answer Pending Moderation
  1. Friday, 18 March 2022 20:55 PM UTC
  2. PowerBuilder
  3. # 3

I am using PB 2021. I have reinstalled the application a couple times and the folder does not exist. Also the installer does not have an option for Demo DB.

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 18 March 2022 21:30 PM UTC
You can use the Demo Apps & DB that comes with PB2021. They key is in the Appeon Installer's start-up. Have a look at the "Options" tab page on the far right hand side. In there you will find prompts for the DB Driver & DBMS to load the Demo DB & Apps to. Make sure though that you install the DBMS first before running the Appeon Installer otherwise, you will not see the various DB options to choose. HTH
  1. Helpful 1
There are no comments made yet.
Jeff Hamilton
Jeff Hamilton Accepted Answer Pending Moderation
  1. Friday, 18 March 2022 22:03 PM UTC
  2. PowerBuilder
  3. # 4

I found the options tab after uninstalling everything and using the offline installer. Now the question is, how can I get the scripts for SQL Server, Oracle, or something else other than SQLAnywhere or PostgreSQL?

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 18 March 2022 23:31 PM UTC
Sorry... The PB Demo DB is only available for either SQLAnyWhere or PostGreSQL only currently.
  1. Helpful
Jeff Hamilton
  1. Jeff Hamilton
  2. Saturday, 19 March 2022 14:22 PM UTC
That is unfortunate. I would expect that a business who is trying to promote their software would have something available for the more popular DB's. Does anyone have the scripts to create the tables and data for SQL Anywhere or PostgreSQL?
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Saturday, 19 March 2022 21:18 PM UTC
SQL Anywhere has a utility called dbunload to create table create scripts. It also creates a script to restore data.
  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.