|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement... |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| Comparing two windows (two pages, two reports, two classes, ... |
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items... |
|
|
|
|
|
|
|
| When creating and developing the different elements of a project (window, query, report, project, ... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| When several data files are used in a query, the query editor automatically searches for the links between these files defined in the analysis... |
|
|
|
|
|
|
|
| The code history is used to... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries... |
|
|
|
|
|
|
|
| The description window of a select query includes several sections... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file... |
|
|
|
|
|
|
|
| Converts:
an ANSI string (Windows) to a UNICODE string.
a buffer containing an ANSI string (Windows) to a buffer containing a UNICODE string.... |
|
|
|
|
|
|
|
| Converts an integer into a date in YYYYMMDD format. |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Shape controls in windows, pages and reports can be handled using different WLanguage properties...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native xBase/FoxPro Connector (or Native xBase/FoxPro Access) module...... |
|
|
|
|
|
|
|
| An application is often intended to be used by several users connected via a network...... |
|
|
|
|
|
|
|
| Performs the following operations:
If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation.
If the file exists, opens the file.... |
|
|
|
|
|
|
|
| A fixed array is an "advanced" type of array... |
|
|
|
|
|
|
|
| The Upload control is used to upload files on the Web server...... |
|
|
|
|
|
|
|
| Action Bars replace the title bar of a window and display different types of information...... |
|
|
|
|
|
|
|
| Automatically extracts and decompresses files from a directory in the file tree of an archive to a physical location. |
|
|
|
|
|
|
|
| Calculates the difference between two times in hundredths of a second. |
|
|
|
|
|
|
|
| Sets the position on the first record of a data file according to the specified browse item. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Usage example of the OrganizerDeleteAppointment function |
|
|
|
|
|
|
|
| Creates the signature of a character string. |
|
|
|
|
|
|
|
| Prints a border with rounded outlines at specified coordinates. |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...... |
|
|
|
|
|
|
|
| The sfLeadConvert type is used to describe the conversion parameters of a lead... |
|
|
|
|
|
|
|
| When an application is used to display or save data in HFSQL files, this data is entered in the current language...... |
|
|
|
|
|
|
|
| Modifies a column in a horizontal Table control. |
|
|
|
|
|
|
|
| The Process property is used to modify the processes to be executed by the events available on a control, window, page, report, etc. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|