PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
This content comes from an automatic translation.
  • NOTE1
  • 1410087510
  • In this lesson
  • NOTE4_1
  • Adapting a site to use an HFSQL Client/Server database
  • Overview
  • Adapting the example
  • HSubstDir
Lesson 11.2. Implementing a Client/Server database
] ]
NOTE1
  • NOTE1_1
  • This lesson will teach you the following concepts
  • Installing a local HFSQL server.
  • Creating a site that uses an HFSQL Client/Server database.

Adapting a site to manage an HFSQL Client/Server database.: Features available in Client/Server mode.
Previous LessonTable of contentsNext Lesson
1410087510
NOTE2
In this lesson
NOTE3
NOTE3_1. Installing a local HFSQL server
The first operation to perform consists in installing an HFSQL server.. This server can be installed locally on the development computer (that's what we are going to do)
If you do not have this media, the HFSQL server setup is also available on our site (%00000028%] [%00000029%).
  1. https://www.windev.com
  2. www.windev.com
  3. To install the HFSQL server locally:
  4. Start the setup program of WEBDEV.
  5. Select "HFSQL Server Setup".
  6. Then, select "Install or update an HFSQL server".
  7. Accept the license agreement.. Choose the platform ("For Windows on this computer")..
    If HFSQL servers are already installed on the current computer

    Select the setup directory and specify the server name and port

    The port 4900 will be used by default
  8. Remark.
    Don't forget to open this port on the firewall in order to connect to the HFSQL server from another computer.

    Specify the name and password of the user with management that will be created by default on the HFSQL server

    By default, this user is "Admin" and has no password
  9. Remark. For security reasons, don't forget to change the administrator password..
  10. If the HFSQL Control Center is not installed or is not accessible from your computer, check the option "Install the HFSQL Control Center". Caution!.
  11. The HFSQL Control Center is required to manage the HFSQL Client/Server database.. The wizard proposes to configure the sending of notifications in order to identify the server dysfunctions in real time.
  12. In our example, go to the next step and indicate that the setting will be performed "Later". The wizard proposes to enable the authentication via Active Directory. Enable this option if necessary.
Validate (or not) the participation in product improvement by allowing us to collect information regarding the use of product

This optional and anonymous collect allows PC SOFT to improve the product features

The setup is performed
NOTE4_1
Creating a site that uses an HFSQL Client/Server database. Creating a WEBDEV site that uses an HFSQL Client/Server database is child's play
  1. You must:
  2. Create the project by asking to create a new database.
  3. Create the analysis by specifying that the databases used by the project will be "HFSQL Client/Server" databases.
  4. Specify the characteristics of the connection to the HFSQL Client/Server server that will be used.
When creating a data file in the analysis

Remark

You can also describe the connection to the HFSQL server by programming. See the online help for more details: "".
Adapting a site to use an HFSQL Client/Server database

Overview

Switching a database from HFSQL Classic mode to Client/Server mode is the most common operation.
WEBDEV propose several solutions to perform this adaptation:
  • perform this adaptation in the data model editor.
  • perform this adaptation from the HFSQL Control Center.
To better understand the different steps, we are going to switch to Client/Server mode the site we made in part 4 of this book, using the first method, the analysis editor.

Adapting the example

Answer

If you did not perform the operations in the previous lessons

in the WEBDEV home page (Ctrl + <), click "Tutorial" and select "Full WEBDEV Site (Answer)".: To adapt the project:
  • Open the "Full_WEBDEV_Site" project if necessary.
    1. Load the analysis of your project in the data model editor
    2. Click among the quick access buttons of WEBDEV menu: The data model editor is displayed.. Open the data model editor
    3. In the ribbon, go to "", group "", and click "". A wizard is opened, allowing you to create a connection.
    4. Analysis: Connection. New connection
    5. Select the type of connection to create: "HFSQL Client/Server"
      • Go to the next step.. Selecting the type of database
      • In the following steps, specify.
      • Choosing the server. the name of the server on which the HFSQL Client/Server server was installed (localhost if it was installed on your computer for example) and the port number
    6. Go to the next step.
    7. the user name and password (to use the administrator, specify the custom login and password when installing the HFSQL server). Go to the next step.. the database name ("Full_WEBDEV_Site" in our example)
    8. Go to the next step.
    9. Type the connection name (keep the proposed name).: Go to the next step and validate
    10. The connection to the database is automatically created. The wizard proposes to associate the different data files found in the analysis with the connection that was just created.
    11. Associating data files with the connection: Click "Yes".
    12. In the next step, select all the data files proposed
    13. Go to the next step.
    14. Choosing the data files: Then, the wizard proposes to copy the data files to the server. Validate ("Copy now").. Copying the data files.
      Select the analysis files that will be copied onto the server

      in our case

      Copying the data files: Go to the next step and validate.
      • The data files in the analysis are automatically changed into HFSQL Client/Server data files and associated with the selected connection. : Data model editor, ... Generate the analysis
      • An automatic modification of data files is automatically proposed
      • Analysis: Generation
    15. Switching to Client/Server mode. tips. Check the code of your project
HSubstDir
Depending on the parameters specified when creating the connection, the connection defined in the analysis can be modified by and .
Triggers.
Previous LessonTable of contentsNext Lesson
Minimum version required
  • Version 24
Comments
Click [Add] to post a comment