|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Ignores errors so that replication between HFSQL servers can continue to run. |
|
|
|
|
|
|
|
| Downloads a document from Google Docs. |
|
|
|
|
|
|
|
| Modifies some parameters of an existing replication between two HFSQL servers. |
|
|
|
|
|
|
|
| Forces the execution of a scheduled backup. |
|
|
|
|
|
|
|
| Reads the replication configuration for an HFSQL server that takes part in one or more replications. |
|
|
|
|
|
|
|
| Starts a session for receiving and reading emails with the IMAP protocol. |
|
|
|
|
|
|
|
| Returns the list of current or interrupted transactions on the server for the specified connection. |
|
|
|
|
|
|
|
| Modifies a scheduled task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| Sends a data to the program connected via DDE. |
|
|
|
|
|
|
|
| Returns the specified information about the server. |
|
|
|
|
|
|
|
| Copies a file located on the local machine to a Hadoop server. |
|
|
|
|
|
|
|
| Deletes a directory from an HFSQL Client/Server database. |
|
|
|
|
|
|
|
| The gglAttachment type is used to define all the advanced characteristics of a file attached to a calendar event. The calendar can be described using the gglCalendar type. This calendar is used by the Google Calendar service. |
|
|
|
|
|
|
|
| Sets the password security policy of an HFSQL server. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 3. |
|
|
|
|
|
|
|
| Unlocks a user account that has been locked due too many unsuccessful login attempts. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 3. |
|
|
|
|
|
|
|
Gets the security policy of an HFSQL server.This new function is available from version 2025 Update 3. |
|
|
|
|
|
|
|
| Specifies whether TCP sockets and WebSockets must go through a SOCKS5 proxy to execute requests. |
|
|
|
|
|
|
|
| Retrieves the list of tables found on an HBase server. |
|
|
|
|
|
|
|
| Deletes a database located on an HFSQL server. |
|
|
|
|
|
|
|
| Enables or disables a scheduled task on an HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Returns the list of recipients for a notification by email. |
|
|
|
|
|
|
|
| Transforms a Spare server into an HFSQL server. This makes it possible to delete replications of a spare server so that it can be used again. For example, this function can be used in the case of a master server that becomes unreachable. This function should only be used in a critical situation. Note: This function is only available from version 2025 - Update 1. |
|
|
|
|
|
|
|
| Refuses a request for stream connection. |
|
|
|
|
|
|
|
| Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
|
| Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
|
| Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
|
| If a transaction is active, rolls back all changes made to the data files since the beginning of the transaction. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| Checks that each user accounts complies with the password security policy associated with the HFSQL server. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 3. |
|
|
|
|
|
|
|
| The gglContactGroup is used to describe and modify a group of contacts used by the Google Contacts service... |
|
|
|
|
|
|
|
| A "Single Page App" is a Web application (Internet or Intranet) whose all pages are grouped in a single page... |
|
|
|
|
|
|
|
| The Compression property is used to manage data compression during a connection (HFSQL Client/Server, etc.) |
|
|
|
|
|
|
|
| Allows you to start an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
|
| Creates an HBase table or modifies the description of an HBase table. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| Modifies the title of next window to open. |
|
|
|
|
|
|
|
| Lists the operations performed on current data files, over the last 24 hours, or on the last 1000 files. These operations include reindexing, recalculation of statistics, memo verification, index verification, etc. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Connects a client to a Modbus server via transmission control protocol (TCP). |
|
|
|
|
|
|
|
| List of SQL functions: Special cases |
|
|
|
|
|
|
|
| Sends a communication request (HTTP request) to a Google service. |
|
|
|
|
|
|
|
| The hbColumnDescription type is used to define the advanced characteristics of a group of columns (items). |
|
|
|
|
|
|
|
| Retrieves the description of an HBase table. |
|
|
|
|
|
|
|
| Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
|
| Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
|
| The gglConnection type is used to describe a connection to the Google services and to manage the authentication to different services... |
|
|
|
|
|
|
|
| Writes cells (values of items) to one or more rows (records) in an HBase table. |
|
|
|
|
|
|
|
| Retrieves the list of documents available on the Google server for the current user. |
|
|
|
|
|
|
|
| The modbusSession type is used to identify a connection to a Modbus server. |
|
|
|
|
|
|
|
| The CtCacheSize property is used to determine and change the maximum number of records that can be stored in the cache of the Native MySQL Connector. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
|
|
|
|
|
|
|
| Usage example of the SQLTransaction function |
|
|
|
|
|
|
|
| Adds a replication between two HFSQL server onto the master server. |
|
|
|
|
|
|
|
| Lists the files shared by a device that uses the OBEX protocol. |
|
|
|
|
|
|
|
| Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
|
| Associates a stream connection request with a Conference control. |
|
|
|
|
|
|
|
The Source property can be used on:- Chart control field field: in this case, the Source property indicates the source of the series: table column, list of values, etc, ...
- connection in which case the Source property is used to identify or define the source of a connection (HFSQL Client/Server, OLE DB, etc.).
|
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| Sends a file to a device that supports the OBEX protocol. |
|
|
|
|
|
|
|
| Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| The gglEvent type is used to describe and modify an event of a calendar... |
|
|
|
|
|
|
|
| Uploads a document to the Google server. |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group for an HFSQL Client/Server database. |
|
|
|
|
|
|
|
| Uploads a document to the Google server. |
|
|
|
|
|
|
|
Waits for: - the replication data on the master server to be sent to the subscriber server.
- the replication data received on the subscriber server to be entirely applied.
|
|
|
|
|
|
|
|
| Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
|
|
|
|
|
|
|
| The gglCalendar type is used to describe and modify a calendar used by the Google Calendar service... |
|
|
|
|
|
|
|
| Used to declare a list of variables whose value will be persistent between the successive calls to a web service. |
|
|
|
|
|
|
|
| Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
|
| Deletes the recipients of an email notification. |
|
|
|
|
|
|
|
| Returns the requested information about the current Wi-Fi connection of the device. |
|
|
|
|
|
|
|
| The CursorOptions property is used to manage the type of cursor used for a connection (Native Connectors, OLE DB, etc.). |
|
|
|
|
|
|
|
| Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Deletes a materialized view from the HFSQL server. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
Validates the current transaction: - the modifications performed on the data file since the start of transaction (HTransactionStart) are validated.
- the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
- the records locked in read-only by the transaction are unlocked.
|
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Automatically associates each column of the query result with a control or with a variable of the application. |
|
|
|
|
|
|
|
| Disconnects a network drive. |
|
|
|
|
|
|
|
| Immediately execute periodic replication between HFSQL servers: replication is triggered ahead of schedule. |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group on an HFSQL server. |
|
|
|
|
|
|
|
| Returns information about a materialized view. |
|
|
|
|
|
|
|
| The hdfsConnection type is used to define the advanced characteristics of a connection to the Hadoop file system (HDFS). |
|
|
|
|
|
|
|
| Associates a drive with a shared network directory. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| Regenerates a data file from its log.
|
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Connects and authenticates the administrator of the SaaS web service. |
|
|
|
|
|
|
|
| Closes the communication opened by DomoOpen. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. |
|
|
|
|
|
|
|
| Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
|
| Checks for the latest version of the HFSQL server that can be automatically updated. |
|
|
|
|
|
|
|
| Deletes an integrity rule between two data files on the server. |
|
|
|
|
|
|
|
| Adds a scheduled task on the server defined by the connection. |
|
|
|
|
|
|
|
| Returns the list of automatic operations in progress on an HFSQL server. |
|
|
|
|
|
|
|
| Allows connecting to the application via the User Groupware web service. |
|
|
|
|
|
|
|
| Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
|
|
|
|
|
|
|
| Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
|
|
|
|
|
|
|
| Starts an email management session based on the selected management mode (POP3, SMTP, IMAP or MS Exchange).
|
|
|
|
|
|
|
|
| Lists the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. |
|
|
|
|
|
|
|
| The emailSMTPSession type is used to access a messaging server by using the SMTP protocol (Simple Mail Transfer Protocol) in order to send emails. |
|
|
|
|
|
|
|
| The gglDocument type is used to handle a Google document... |
|
|
|
|
|
|
|
| SOCKS5 is a simple network protocol intended to standardize the use of proxies for applications... |
|
|
|
|
|
|
|
| Ignores errors so that replication between HFSQL servers can continue to run. |
|
|
|
|
|
|
|
| Adds an integrity rule between two files on the server. |
|
|
|
|
|
|
|
| Publishes a message on the MQTT broker. |
|
|
|
|
|
|
|
| Reads cells (values of items) of a row (record) in an HBase table. |
|
|
|
|
|
|
|
| Executes a stored procedure in asynchronous mode. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. |
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| Deletes a replication between two HFSQL servers. |
|
|
|
|
|
|
|
| Adds a user to a database. |
|
|
|
|
|
|
|
Returns the characteristics of all the columns (or items):- for a given table.
- for a given query.
|
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Returns the connection quality index. The higher the index, the faster the connection. |
|
|
|
|
|
|
|
| Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
Deletes:- one or more cells from an HBase table for one or more columns.
- a row from an HBase table.
|
|
|
|
|
|
|
|
| Used to connect to a device that supports the OBEX protocol.
Reminder: The OBEX protocol is a data transfer protocol that can be used via infrared beams and Bluetooth. |
|
|
|
|
|
|
|
| Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Adds a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. |
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
|
| Specifies and configures the server used to send notifications by the HFSQL server. |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| If a transaction is active, rolls back all changes made to the data files since the beginning of the transaction. |
|
|
|
|
|
|
|
| Used to find out and modify some settings of HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| This help page explains how to add a secure payment into a WEBDEV website... |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| Usage example of the EmailReadMessage function |
|
|
|
|
|
|
|
| Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more data files. |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| All the features in WEBDEV Account Manager can be used via command line... |
|
|
|
|
|
|
|
| Specifies whether the communication functions that use FTP must go through a proxy to run their requests. |
|
|
|
|
|
|
|
Copies an HFSQL data file (.fic, .ndx, .ftx, .sdx and .mmo files, if any):- from the HFSQL server to the server (to perform a backup for example).
- from the HFSQL server to the client (to perform a local backup for example).
- from the client to the HFSQL server (to update the data files for example).
- from an HFSQL server to antoher HFSQL server.
|
|
|
|
|
|
|
|
Used to restore: - an immediate backup (performed by HBackup or via the HFSQL Control Center),
- a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center.
|
|
|
|
|
|
|
|
| A deployment diagram shows the physical layout of the hardware components (nodes) used in a system as well as the association between the executable programs and these components... |
|
|
|
|
|
|
|
| Returns information about one or more backups performed on an HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Opens a connection to a Hadoop server. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the name of the page requested at the start of the session. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| The CtExtendedInfo property gets the additional information inserted into the database connection string. |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| Modifies the operating mode of an LDAP session. |
|
|
|
|
|
|
|
| The gglPostalAddress type is used to describe and modify the postal address of a contact... |
|
|
|
|
|
|
|
| Facebook is the world's most popular social network. It is commonly used by companies to reach their customers... |
|
|
|
|
|
|
|
| The gglOrganization type is used to describe the companies and organizations to which a contact belongs... |
|
|
|
|
|
|
|
| The gglPhoneNumber type is used to describe and modify the phone number of a contact... |
|
|
|
|
|
|
|
| Restarts a fax in the spooler. |
|
|
|
|
|
|
|
| Facebook is the world's most popular social network. It is commonly used by companies to reach their customers... |
|
|
|
|
|
|
|
| Returns the runtime status report of a DDE function. |
|
|
|
|
|
|
|
| The gglInstantMessaging type is used to describe and modify the characteristics of an instant messaging program used by a contact... |
|
|
|
|
|
|
|
| Retrieves the list of documents available on the Google server for the current user. |
|
|
|
|
|
|
|
| Used to find out whether an electrical device (compatible with the X10 protocol) is switched on or off. |
|
|
|
|
|
|
|
| Fills a calendar that was previously retrieved: the events corresponding to the calendar are retrieved via a custom query. |
|
|
|
|
|
|
|
| Fills a calendar that was previously retrieved: the events corresponding to the calendar are retrieved via a custom query. |
|
|
|
|
|
|
|
| The gglOverride type is used to define information about event notification overrides. |
|
|
|
|
|
|
|
| The CtCursorOptions property gets the cursor type used when connecting to an external database. |
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized... |
|
|
|
|
|
|
|
| The FaxCompleteStatus structure is automatically filled during the call to FaxStatus... |
|
|
|
|
|
|
|
| Sends a command to one or more electrical devices compatible with the X10 protocol. |
|
|
|
|
|
|
|
The CacheSize property is used to:- Get the maximum number of records that can be stored in the cache of the Native MySQL Connector.
- Change the maximum number of records that can be stored in the cache of the Native MySQL Connector.
|
|
|
|
|
|
|
|
| Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Allows you to find out the status of an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
|
| The User Groupware in automatic mode offers many possibilities... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| What's new in WINDEV 2026 in the What's new 2026 brochure. |
|
|
|
|
|
|
|
| WEBDEV 2026 new features in the 2026 New Features brochure. |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| What's new in WINDEV Mobile 2026 is presented in the What's new 2026 brochure. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|