|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Ignores errors so that replication between HFSQL servers can continue to run. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| The gglAuthor type is used to identify the author of a Google element... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
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.).
|
|
|
|
|
|
|
|
| Executes a stored procedure in asynchronous mode. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
|
| The memcachedConnection type is used to define the characteristics of a connection to a Memcached server. |
|
|
|
|
|
|
|
| If a transaction is in progress, rolls back all operations performed on data files in transactions since the start of the transaction. |
|
|
|
|
|
|
|
| Lists the replications available on a master HFSQL server. |
|
|
|
|
|
|
|
| Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Switches off one or more electrical devices compatible with the X10 protocol. |
|
|
|
|
|
|
|
| Allows you to find out the properties of a data file located in an HFSQL server. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group on an HFSQL server. |
|
|
|
|
|
|
|
| Starts an Outlook section.
|
|
|
|
|
|
|
|
| Deletes the recipients of an email notification. |
|
|
|
|
|
|
|
| The gglNotification type is used to define information about event notifications in a calendar. |
|
|
|
|
|
|
|
| Starts a session for receiving and reading emails with the IMAP protocol. |
|
|
|
|
|
|
|
| Manages authentication on a Google server (via the "OAuth 2.0" authentication mode). |
|
|
|
|
|
|
|
| Downloads a document from Google Docs. |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file. |
|
|
|
|
|
|
|
| Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Deletes a set of stored procedures from an HFSQL server. |
|
|
|
|
|
|
|
Gets the security policy of an HFSQL server.This new function is available from version 2025 Update 3. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file. |
|
|
|
|
|
|
|
| Deletes a scheduled backup from an HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Deletes a scheduled task from an HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Modifies a backup scheduling. |
|
|
|
|
|
|
|
| Sends a data to the program connected via DDE. |
|
|
|
|
|
|
|
| Downloads a document from Google Docs. |
|
|
|
|
|
|
|
| Deletes a backup previously created with HBackup. |
|
|
|
|
|
|
|
| Copies a file located on the local machine to a Hadoop server. |
|
|
|
|
|
|
|
| Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
|
| Modifies the properties of an HFSQL server. |
|
|
|
|
|
|
|
| Usage example of the HDeclareExternal function |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Returns the list of current or interrupted transactions on the server for the specified connection. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The gglContactGroup is used to describe and modify a group of contacts used by the Google Contacts service... |
|
|
|
|
|
|
|
| Specifies whether TCP sockets and WebSockets must go through a SOCKS5 proxy to execute requests. |
|
|
|
|
|
|
|
| Modifies the priority of a client application. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| If a transaction is in progress, rolls back all operations performed on data files in transactions since the start of the transaction. |
|
|
|
|
|
|
|
| Deletes a directory from an HFSQL Client/Server database. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
|
|
|
|
|
|
|
| Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
|
| Reads a parameter that was saved from a stored procedure by HSaveParameter. |
|
|
|
|
|
|
|
| A "Single Page App" is a Web application (Internet or Intranet) whose all pages are grouped in a single page... |
|
|
|
|
|
|
|
| Returns the characteristics of an HFSQL Classic or Client/Server data file. |
|
|
|
|
|
|
|
| The Compression property is used to manage data compression during a connection (HFSQL Client/Server, etc.) |
|
|
|
|
|
|
|
| Deletes a database located on an HFSQL server. |
|
|
|
|
|
|
|
| Returns the list of recipients for a notification by email. |
|
|
|
|
|
|
|
| Connects a client to a Modbus server via transmission control protocol (TCP). |
|
|
|
|
|
|
|
| Allows you to start an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
|
| Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
|
| The modbusSession type is used to identify a connection to a Modbus server. |
|
|
|
|
|
|
|
| Enables or disables a scheduled task on an HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Modifies the title of next window to open. |
|
|
|
|
|
|
|
| Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
|
| Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
|
| The gglConnection type is used to describe a connection to the Google services and to manage the authentication to different services... |
|
|
|
|
|
|
|
| List of SQL functions: Special cases |
|
|
|
|
|
|
|
| Sends a communication request (HTTP request) to a Google service. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| The hbColumnDescription type is used to define the advanced characteristics of a group of columns (items). |
|
|
|
|
|
|
|
| The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Connector, etc. |
|
|
|
|
|
|
|
| Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Usage example of the SQLTransaction function |
|
|
|
|
|
|
|
| Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
|
|
|
|
|
|
|
| Lists the files shared by a device that uses the OBEX protocol. |
|
|
|
|
|
|
|
| Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
|
|
|
|
|
|
|
| Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
|
Returns the characteristics of all the columns (or items):- for a given table.
- for a given query.
|
|
|
|
|
|
|
|
| Deletes a replication between two HFSQL servers. |
|
|
|
|
|
|
|
| Adds recipients for the notifications sent by email. |
|
|
|
|
|
|
|
| Forces the execution of a scheduled backup. |
|
|
|
|
|
|
|
| Associates a stream connection request with a Conference control. |
|
|
|
|
|
|
|
| Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
|
| The gglDocument type is used to handle a Google document... |
|
|
|
|
|
|
|
| Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Loads an XML document from a file, a URL or a string into an xmlDocument variable. |
|
|
|
|
|
|
|
| WebSockets enable bidirectional communication between web applications (Intranet or Internet sites run in a browser) and web servers... |
|
|
|
|
|
|
|
| Retrieves the description of an HBase table. |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
|
| Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
|
| Publishes a message on the MQTT broker. |
|
|
|
|
|
|
|
| Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file. |
|
|
|
|
|
|
|
| SOCKS5 is a simple network protocol intended to standardize the use of proxies for applications... |
|
|
|
|
|
|
|
| Reads cells (values of items) of a row (record) in an HBase table. |
|
|
|
|
|
|
|
| Ignores errors so that replication between HFSQL servers can continue to run. |
|
|
|
|
|
|
|
| Connects the current computer to an FTP server (File Transfer Protocol). |
|
|
|
|
|
|
|
| Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| The emailSMTPSession type is used to access a messaging server by using the SMTP protocol (Simple Mail Transfer Protocol) in order to send emails. |
|
|
|
|
|
|
|
| Regenerates a data file from its log.
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Starts an email management session based on the selected management mode (POP3, SMTP, IMAP or MS Exchange).
|
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
|
| Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
|
|
|
|
|
|
|
| The gglCalendar type is used to describe and modify a calendar used by the Google Calendar service... |
|
|
|
|
|
|
|
| Closes the communication opened by DomoOpen. |
|
|
|
|
|
|
|
| Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. |
|
|
|
|
|
|
|
| The hdfsConnection type is used to define the advanced characteristics of a connection to the Hadoop file system (HDFS). |
|
|
|
|
|
|
|
| The Encryption property allows you to manage the type of encryption used between Client computers and an HFSQL server. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Associates a drive with a shared network directory. |
|
|
|
|
|
|
|
| Enables or disables the management of an integrity constraint on a file link. |
|
|
|
|
|
|
|
| Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
|
|
|
|
|
|
|
| Disconnects a network drive. |
|
|
|
|
|
|
|
| Automatically associates each column of the query result with a control or with a variable of the application. |
|
|
|
|
|
|
|
| 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.). |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
|
| Used to declare a list of variables whose value will be persistent between the successive calls to a web service. |
|
|
|
|
|
|
|
| Specifies and configures the server used to send notifications by the HFSQL server. |
|
|
|
|
|
|
|
| The gglEvent type is used to describe and modify an event of a calendar... |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
| Uploads a document to the Google server. |
|
|
|
|
|
|
|
| Uploads a document to the Google server. |
|
|
|
|
|
|
|
| Opens a connection to a specific database. |
|
|
|
|
|
|
|
| Sends a file to a device that supports the OBEX protocol. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| The User Groupware in automatic mode offers many possibilities... |
|
|
|
|
|
|
|
| Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Used to find out and modify some settings of HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| Describes a new connection to an external database. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Usage example of the EmailReadMessage function |
|
|
|
|
|
|
|
| All the features in WEBDEV Account Manager can be used via command line... |
|
|
|
|
|
|
|
| WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
|
|
|
|
|
|
|
|
| Specifies whether the communication functions that use FTP must go through a proxy to run their requests. |
|
|
|
|
|
|
|
| Returns information about one or more backups performed on an HFSQL Client/Server server. |
|
|
|
|
|
|
|
| Usage example of the HCopyFile function |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| The gglLocation type is used to describe and modify the location of an event found in a Google calendar... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized... |
|
|
|
|
|
|
|
| Allows you to find out the status of an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|