|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Creates an empty data file (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 data file doesn't exist, create an empty data file (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 data file exists, opens the data file.
|
|
|
|
|
|
|
|
| Initializes the range of automatic identifiers for the description file of subscriber replica (".rpl" extension). |
|
|
|
|
|
|
|
Determines:- whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
- whether a view or a query was defined.
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Usage example of the HAdd function |
|
|
|
|
|
|
|
| Defines the password used to create or open a data file. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL data file. |
|
|
|
|
|
|
|
| WDMap is used to view the records found in a data file... |
|
|
|
|
|
|
|
| Deletes HFSQL data files (.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 analysis... |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis... |
|
|
|
|
|
|
|
| This page presents the main aspects and requirements of the Native MariaDB Connector... |
|
|
|
|
|
|
|
| Usage example of the Size property |
|
|
|
|
|
|
|
| Remarks and specific features of the Native MySQL Connector |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| The Native MySQL Connector (also called "Native MySQL Access") creates "InnoDB" tables to support locks and transactions on a MySQL database... |
|
|
|
|
|
|
|
| Remarks and specific features of the Native Oracle Connector |
|
|
|
|
|
|
|
| The analysis proposes two types of Unicode items ... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQLite Connector. |
|
|
|
|
|
|
|
| The KeyExpression property is used to set the different components of a composite key. |
|
|
|
|
|
|
|
| When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to import and handle a definition of XML files via the data model editor... |
|
|
|
|
|
|
|
| Usage example of the HChangeName function |
|
|
|
|
|
|
|
| Gets the properties of a data file located in an HFSQL server. |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Initializes or reinitializes a replication defined by the replication editor (ReplicEdit). |
|
|
|
|
|
|
|
| Changes the password of an HFSQL Classic or HFSQL Client/Server data file. |
|
|
|
|
|
|
|
| WDMap can be used both to determine whether an HFSQL data file should be reindexed and to reindex an HFSQL data file... |
|
|
|
|
|
|
|
| Some WLanguage functions are not available in Reports & Queries... |
|
|
|
|
|
|
|
| When an application displays or saves data in HFSQL data files, this data is typed in the current language... |
|
|
|
|
|
|
|
| Modifies the physical name of a data file. |
|
|
|
|
|
|
|
| Remarks and specific features of Native Progress Connector... |
|
|
|
|
|
|
|
| Remarks and specific features of Native Informix Connector |
|
|
|
|
|
|
|
| WDMap is a tool used to view and handle a data file while developing an application... |
|
|
|
|
|
|
|
| The User Macro-Codes are sections of WLanguage code allowing the end user to customize his application... |
|
|
|
|
|
|
|
| Associates the data directory specified in the analysis with a directory found on disk. |
|
|
|
|
|
|
|
| Allows you to define the characteristics of the sort for the Unicode items found in a data file. |
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized... |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| A FullTextIndex description variable is used to describe one or more full-text indexes programmatically. |
|
|
|
|
|
|
|
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 data file.
|
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| To migrate a WEBDEV site to PHP... |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing... |
|
|
|
|
|
|
|
| Sets the rights granted to a user or group for an HFSQL Client/Server database. |
|
|
|
|
|
|
|
| Several file descriptions can be grouped into a "Custom-Folder"... |
|
|
|
|
|
|
|
| Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
|
| Creates an empty data file (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)... |
|
|
|
|
|
|
|
| Usage example of the HErrorInfo function |
|
|
|
|
|
|
|
| Usage example of the HDeclare function |
|
|
|
|
|
|
|
| The LanguageDescribed property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item). |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SAP ASE Connector (also called Native Sybase Access)... |
|
|
|
|
|
|
|
| List of events associated with the project |
|
|
|
|
|
|
|
| Server triggers are stored procedures executed by the server before or after a write operation performed on a database file... |
|
|
|
|
|
|
|
| HDescribeFullTextIndex example |
|
|
|
|
|
|
|
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).
|
|
|
|
|
|
|
|
| Usage example of the KeyExpression property |
|
|
|
|
|
|
|
The property Name allows you to:- find out the name of the font associated with a variable of type Font.
- know the name of a field, report or report block.
- know the name of a field, a group of fields or a window.
- know the name of a field, a group of fields or a page.
- know and modify the name of a heading, data file, full-text index or semantic index.
|
|
|
|
|
|
|
|
Copies: - the content of the current record (loaded in memory) to the current data file record.
- the content of the Record variable to the current data file record.
|
|
|
|
|
|
|
|
| Usage example of the HModify function |
|
|
|
|
|
|
|
Specifies the mode for processing the errors: - the errors are processed by WINDEV
- the errors are processed by the program.
|
|
|
|
|
|
|
|
| Remarks and specific features of Native PostgreSQL Connector... |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files... |
|
|
|
|
|
|
|
| WDModFic is a tool for automated modification of data files on development and end-user workstations... |
|
|
|
|
|
|
|
The TypeDescription property is used to: - Get the type used by an Enumeration or Combination item. This item was defined in the data model editor or programmatically.
- Define the type used by an Enumeration or Combination item (only for items defined programmatically).
|
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| Usage example of the HCopyRecord function |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|