|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creates an empty table (file extension ".FIC") with index file, full-text index file and memo file if required. |
|
|
|
|
|
|
|
| Example of the HCreation function |
|
|
|
|
|
|
|
Performs the following operations: - If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
- If the table exists, opens the table.
|
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".rpl" extension). |
|
|
|
|
|
|
|
| Deletes a directory from an HFSQL Client/Server database. |
|
|
|
|
|
|
|
| The Native MariaDB Connector creates "InnoDB" tables to support locks and transactions on a MariaDB database... |
|
|
|
|
|
|
|
Determines:- whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
- whether a view or a query was defined.
|
|
|
|
|
|
|
|
| Defines the password used to create or open a table. |
|
|
|
|
|
|
|
| Deletes all records from a table, an HFSQL view or a query. |
|
|
|
|
|
|
|
| WDMap is used to view the records found in a table... |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL table. |
|
|
|
|
|
|
|
| Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector... |
|
|
|
|
|
|
|
| To use an Oracle database with the Native Connector, the structure of ORACLE tables must be imported into the WINDEV or WEBDEV database schema... |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model database schema... |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database... |
|
|
|
|
|
|
|
| The database schema proposes two types of Unicode items ... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native Oracle Connector |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQLite Connector. |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
| Gets the properties of a table located in an HFSQL server. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to import and handle a definition of XML files via the data model editor... |
|
|
|
|
|
|
|
| Initializes or reinitializes a replication defined by the replication editor (ReplicEdit). |
|
|
|
|
|
|
|
| Some WLanguage functions are not available in Reports & Queries... |
|
|
|
|
|
|
|
| WDMap can be used both to determine whether an HFSQL table should be reindexed and to reindex an HFSQL table... |
|
|
|
|
|
|
|
| The User Macro-Codes are sections of WLanguage code allowing the end user to customize his application... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| Remarks and specific features of Native Progress Connector... |
|
|
|
|
|
|
|
Specifies the useful size of an internal window with automatic scrollbars. The useful size corresponds to the full size of the internal window: - Width of the internal window.
- Height of the internal window.
|
|
|
|
|
|
|
|
| This feature is used to signal that a table cannot be modified after writing... |
|
|
|
|
|
|
|
| To migrate a WEBDEV site to PHP... |
|
|
|
|
|
|
|
| WDMap is a tool used to view and handle a table while developing an application... |
|
|
|
|
|
|
|
The Charset property is used to: - Get the character set used by a Font variable.
- Change the character set used by a Font variable.
- Get the character set used by an HFSQL table.
|
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Allows you to define the characteristics of the sort for the Unicode items found in a table. |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group for an HFSQL Client/Server database. |
|
|
|
|
|
|
|
| When an application displays or saves data in HFSQL tables, this data is typed in the current language... |
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized... |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
|
| Creates an empty table (extension ".FIC") with index file, full-text index file, spatial index file, and memo file if required. |
|
|
|
|
|
|
|
| Most WLanguage functions can be used in the events of a report (created with the report editor)... |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| List of events associated with the project |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SAP ASE Connector (also called Native Sybase Access)... |
|
|
|
|
|
|
|
| Server triggers are stored procedures executed by the server before or after a write operation performed on a database file... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
Retrieves and/or changes the character set used:- by all the screen fonts.
- by all the operations performed on the character strings (functions and/or operators).
|
|
|
|
|
|
|
|
| WDModFic is a tool for automated modification of tables on development and end-user workstations... |
|
|
|
|
|
|
|
| Remarks and specific features of Native PostgreSQL Connector... |
|
|
|
|
|
|
|
| This chapter covers the following topics... |
|
|
|
|
|
|
|
| List of constants used by the HFSQL functions. |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
| The "Logs" tab is used to see the details of logs for a specific period... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|