|
|
The FullName property is used to find out the full name:- of a control.
- of a window.
- of a menu option.
- of a table column.
|
|
|
|
|
|
|
|
| List of SQL functions: Special cases |
|
|
|
|
|
|
|
| Creates an XML file with data from a Looper control (Looper control based on a data file or populated programmatically). |
|
|
|
|
|
|
|
| Creates a Word file (.RTF) using the data from a Looper control. |
|
|
|
|
|
|
|
| MCI functions are used to easily handle the media files... |
|
|
|
|
|
|
|
| Returns the name of current element (tag or attribute). |
|
|
|
|
|
|
|
| Whatever the platform used, the data stored in HFSQL data files is in ANSI format. |
|
|
|
|
|
|
|
| Searches for a value in an attribute of a Looper control. |
|
|
|
|
|
|
|
| Two types of browse can be used to browse the result of a query run by SQLExec... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to Progress ... |
|
|
|
|
|
|
|
| The Index property indicates the physical index (physical order) of an item in a record.
|
|
|
|
|
|
|
|
| Two methods can be used to pass parameters to a query with parameters used in a window or in a control (List Box, Combo Box or Table control for example) ... |
|
|
|
|
|
|
|
The Native Oracle Connector is used to:- specify the input values during the call to a stored procedure.
- retrieve the output values after a call to a stored procedure.
|
|
|
|
|
|
|
|
| Creates a Word file (.RTF) from the data found in a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Creates an XML file from the data found in a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Returns the name of the archived file currently handled by the functions for adding and extracting files. |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL data files specified by the user when installing the application. |
|
|
|
|
|
|
|
| Identifies the window that was in edit before the window that is currently in edit (for the same project). |
|
|
|
|
|
|
|
| Adds an element to a memory area. |
|
|
|
|
|
|
|
| Establishes a remote connection. |
|
|
|
|
|
|
|
| Operators { and operators } operators are used to access a field, variable, class member or data file item by dynamically constructing the name of the field, variable, class member or item... |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Returns specific information about a Bluetooth device. |
|
|
|
|
|
|
|
| Converts a numeric value into a binary string in order to perform a search on a numeric key. |
|
|
|
|
|
|
|
| Returns the name of Nth control found in the specified element. |
|
|
|
|
|
|
|
| Retrieves the content of a Memo column from the query result, for the current row. |
|
|
|
|
|
|
|
| Restarts a paused service. |
|
|
|
|
|
|
|
| WINDEV allows you to test a project using the corresponding executable... |
|
|
|
|
|
|
|
| Retrieves the value of a cookie saved on the computer of Web user. |
|
|
|
|
|
|
|
| Waits for a service to be in a specific status. |
|
|
|
|
|
|
|
| Modifies the configuration of a service according to the information given in the members of the Service variable. |
|
|
|
|
|
|
|
| You can manipulate Edit controls programmatically... |
|
|
|
|
|
|
|
| Returns the name of parent tag for the current element (tag or attribute). |
|
|
|
|
|
|
|
| The colors of a Table control (row background, text of rows, etc.) are defined in the control description... |
|
|
|
|
|
|
|
Returns the name of a file "uploaded" by the Web user. This file must have been uploaded: - via an "Upload" edit control.
- via a single-file or multi-file Upload field.
|
|
|
|
|
|
|
|
| Used to handle specific features on the objects found in the current page. |
|
|
|
|
|
|
|
The RichEdit property is used to manage the RTF (Rich Text Format) type: - of an edit control or Static Text control found in a window.
- of a Static Text control found in a report.
|
|
|
|
|
|
|
|
| Returns the different elements of a path: drive, directories, name and extension of the file. |
|
|
|
|
|
|
|
| Associates a drive with a shared network directory. |
|
|
|
|
|
|
|
| Defines the next control that will be in edit in the current window. |
|
|
|
|
|
|
|
| Deletes a subkey from the Windows registry. |
|
|
|
|
|
|
|
| Returns the name of directory used to store the temporary files. |
|
|
|
|
|
|
|
| Creates and fills a text file with the content of a text control or text variable (string variable, edit control in a window, Static Text control in a report, ...). |
|
|
|
|
|
|
|
| Inserts an element into a List Box, ListView or Combo Box control populated programmatically. |
|
|
|
|
|
|
|
| Stops the current process and forces the input in the specified control, window or page. |
|
|
|
|
|
|
|
| Returns the short name of a file or directory. |
|
|
|
|
|
|
|
Allows you to:- Sort a Looper control according to one or more attributes.
- Sort a Looper control on all its attributes.
- Cancel a sort that was performed beforehand (which means ignore the sort).
|
|
|
|
|
|
|
|
| Specifies the location of user classes required to run the Java application or the Java applet. |
|
|
|
|
|
|
|
| Starts a Java application or a Java applet by invoking the "Main" method of a given Java class. |
|
|
|
|
|
|
|
| Starts a specific static function of a given Java class. |
|
|
|
|
|
|
|
| Displays a TreeView control from a specified element (node or leaf) or returns the name of the first element displayed in a TreeView control. |
|
|
|
|
|
|
|
| Identifies the window currently in edit. |
|
|
|
|
|
|
|
| Modifies the name of a file. |
|
|
|
|
|
|
|
| Returns the long name of a file or directory. |
|
|
|
|
|
|
|
| A Data Source variable is used to describe a temporary data source (query, view, alias, etc.). |
|
|
|
|
|
|
|
The Variant type is used to:- store any value of simple type: Boolean, Numerical (Monetary, Real, Integer, ...), Character and String, Date (Date, Time, DateTime and Duration), ...
- store named or indexed subelements.
- store any complex type value: structures, classes, advanced types, arrays, associative arrays, queues, stacks and lists.
- handle the NULL value in WLanguage.
- store interactions with ActiveX objects and Automation programming.
|
|
|
|
|
|
|
|
| Returns the name of a unique temporary file. |
|
|
|
|
|
|
|
| The Component property configures the different components of a composite key. |
|
|
|
|
|
|
|
| The CtDescribedOLEDBProvider property gets and sets the name of the OLE DB provider (also called OLE DB server). |
|
|
|
|
|
|
|
| Usage example of the fWriteLine function |
|
|
|
|
|
|
|
| Enables input in the search area in the column title of the Table or Treeview Table control. |
|
|
|
|
|
|
|
| The State property gets and sets the state of an element.
|
|
|
|
|
|
|
|
The Extension property is used to:- get the extension of a data file defined in the data model editor or programmatically.
- define the extension of a file (when the file is described through programming only).
|
|
|
|
|
|
|
|
The Group property is used to: - find out whether the control belongs to a group of controls. If the control belongs to one or more groups, the Group property can be used to identify these groups of controls.
- associate a control with a group of controls.
|
|
|
|
|
|
|
|
| Emails the data found in a page currently displayed in the browser. |
|
|
|
|
|
|
|
| Creates an Excel file with the data from a Table or TreeView Table control. |
|
|
|
|
|
|
|
| Returns the content of an item found in the current record (in the data file, view, query, ...). |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
The SortType property is used to:- Find out the sort direction defined for an item or for a component of a composite key. This item was defined in the data model editor or programmatically.
- Define the sort direction for an item or for a component of a composite key (when describing the item through programming).
|
|
|
|
|
|
|
|
The ReturnedValue property is used to:- Get and change the value returned by a window, page or report.
- Get and change the value returned by an option in a Radio Button control.
|
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
| The sort is used to organize the information displayed in the report... |
|
|
|
|
|
|
|
| Sets the position on the last row of the query result. |
|
|
|
|
|
|
|
| The window that opens another window is called parent window ; the windows opened by the parent window are called child windows... |
|
|
|
|
|
|
|
| Sends a control message to a service. |
|
|
|
|
|
|
|
| A Table control (populated programmatically, based on a data file or based on a variable) can include Combo Box columns... |
|
|
|
|
|
|
|
| In some cases, it may be useful to run the same query multiple times while modifying one or more parameters... |
|
|
|
|
|
|
|
| Here are the main points of programming Table fields linked to a data file |
|
|
|
|
|
|
|
| Here is an overview of how to manipulate Table controls populated programmatically in WLanguage. |
|
|
|
|
|
|
|
| A data-bound report is used to print the records coming from a single data file (HFSQL Classic or Client/Server, accessed via a Native Access, ... |
|
|
|
|
|
|
|
| Asks a service to re-read its configuration information. |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files... |
|
|
|
|
|
|
|
| Returns the current status of a service. |
|
|
|
|
|
|
|
| A report based on a Table control is used to directly print the information displayed in the control (data-bound or populated programmatically) ... |
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector... |
|
|
|
|
|
|
|
| Returns information regarding the configuration of a service. |
|
|
|
|
|
|
|
Allows you to configure the exports performed from the report viewer: - parameters for sending emails.
- parameters for creating the different files.
|
|
|
|
|
|
|
|
The SortOption property gets and sets the sort options used in:- text columns in Table controls,
- text columns in Treeview Table controls,
- List Box and ListView controls,
- Combo Box controls,
- attributes of Looper controls,
- images, clickable images and thumbnails with automatic sequence.
|
|
|
|
|
|
|
|
| Imports a Text file into an HFSQL Classic or Client/Server data file. This data file must have been defined in the data model editor, or declared with HDeclare, HDeclareExternal or HDescribeFile). |
|
|
|
|
|
|
|
| This page explains how to program TreeView Table controls... |
|
|
|
|
|
|
|
| Writing an email in WLanguage consists in filling the email structure of WLanguage... |
|
|
|
|
|
|
|
| This help page explains how to read an email from a WINDEV application and how to display its content in a WINDEV application. |
|
|
|
|
|
|
|
| Returns information about the server logs. |
|
|
|
|
|
|
|
| To send faxes from an application or from a site, WINDEV and WEBDEV propose several functions allowing you to send faxes via the system fax server available in Windows XP and Windows 2000... |
|
|
|
|
|
|
|
| Initializes an OLE control with an OLE object. |
|
|
|
|
|
|
|
| To use an SQL Server database with the Native Connector (or "Native Access"), you can use SQL functions... |
|
|
|
|
|
|
|
| Dynamically compile a Procedure whose source code is supplied (dynamic compilation). |
|
|
|
|
|
|
|
| In this example, the application must manage a video conference between two computers... |
|
|
|
|
|
|
|
| Connects a stream (and the associated control) to a specific address. |
|
|
|
|
|
|
|
| WDModFic is a tool for automated modification of data files on development and end-user workstations... |
|
|
|
|
|
|
|
| Creates an Excel file with data from a RepeatString field (RepeatString field file or RepeatString field memory). |
|
|
|
|
|
|
|
| Deletes a scheduled task. |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
|
|
|
|
|
|
|
| Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers. |
|
|
|
|
|
|
|
| Returns the list of items for the current Notes document in Lotus Notes. |
|
|
|
|
|
|
|
| Returns the name of a column found in a Table or Treeview Table control. |
|
|
|
|
|
|
|
| Stores the current file context (current record, filter, pointers). |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application that uses HFSQL Client/Server data files, WDInst allows you to... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to... |
|
|
|
|
|
|
|
| Allows you to start an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
|
| Returns a debug information. |
|
|
|
|
|
|
|
Executes an XPATH query: - in an XML document.
- in an xmlDocument variable.
|
|
|
|
|
|
|
|
| Creates a logical alias of a data file (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Usage example of the HForward function |
|
|
|
|
|
|
|
| Creates the description file of a Master Replica (logged replication or universal replication). |
|
|
|
|
|
|
|
| WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application... |
|
|
|
|
|
|
|
| Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
|
|
|
|
|
|
|
| Calculates the width (in millimeters) of the text to print, according to the specified font. |
|
|
|
|
|
|
|
| Usage example of the HReadLast function |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Reads a record in a file according to a given record number. |
|
|
|
|
|
|
|
| Positions on the previous row of the query result. |
|
|
|
|
|
|
|
| Retrieves the content of a Text Memo column found in the query result, for the current line. |
|
|
|
|
|
|
|
| Returns the list of assignments for the data files handled by the current application, which means the list of physical files corresponding to the files described in the analysis. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| List all the tables that can be accessed by the connected database system. |
|
|
|
|
|
|
|
| Calculates the height of the font for the text to print (in millimeters). |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| The Identifier property gets and sets the name of the current computer shown to the participants who receive the audio or video stream. This name can be a number, for example. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Imports a Hyper File 5.5 file into an HFSQL Classic file. |
|
|
|
|
|
|
|
| Retrieves the specified information about the version of an executable or DLL. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer a Native xBase/FoxPro Connector (or Native xBase/FoxPro Access) module... |
|
|
|
|
|
|
|
| The character strings can be handled by specific WLanguage functions or by the +, [[ and ]] operators... |
|
|
|
|
|
|
|
| Creates the description file of a subscriber replica. |
|
|
|
|
|
|
|
| Ends the description of the structure of an xBase data file programmatically. |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search). |
|
|
|
|
|
|
|
| Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search). |
|
|
|
|
|
|
|
| Modifies the specified record or the record found in memory in the data file (query or view). |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| Sends the character string passed as parameter to the print buffer. |
|
|
|
|
|
|
|
| The use of SQL functions to manipulate Informix data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| Configures the print destination. |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
Modifies a row in: - a Table control,
- a TreeView Table control,
- tables displayed in a Combo Box control.
|
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| The use of SQL functions to handle Progress data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| Project Management Hub: project management (view, create, ...) |
|
|
|
|
|
|
|
| The use of SQL functions to handle Sybase data does not require importing the file structure into the analysis... |
|
|
|
|
|
|
|
| Allows you to find out the status of an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
|
| Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default). |
|
|
|
|
|
|
|
Opens and initializes:- a serial port.
- a parallel port.
- an infrared port.
|
|
|
|
|
|
|
|
| Reads an incoming according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook). |
|
|
|
|
|
|
|
| The ScheduledTask structure is used to define all the events that will define the execution of a task... |
|
|
|
|
|
|
|
| The ScheduledTask structure is used to define the characteristics of a scheduled task... |
|
|
|
|
|
|
|
| To use a DB2 database with Native Connector, the structure of DB2 tables must be imported into the WINDEV or WEBDEV analysis... |
|
|
|
|
|
|
|
| Allows you to find out or modify the name of the CD or DVD to burn. |
|
|
|
|
|
|
|
| Usage example of the EmailReadMessage function |
|
|
|
|
|
|
|
| Reads the header of an incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
|
|
|
|
|
|
|
|
| The SQL functions can be used to handle the MySQL database... |
|
|
|
|
|
|
|
| The hierarchical organization in class and sub-class has allowed to create the notion of inheritance... |
|
|
|
|
|
|
|
Adds a contact: - in a Lotus Notes or Outlook address book.
- in the contacts list of your device (Android, iPhone or iPad).
|
|
|
|
|
|
|
|
| In a report based on a text file, the information to print is read from a text file or is directly assigned in the report controls... |
|
|
|
|
|
|
|
| A report based on a memory area is used to print the records stored in a memory area... |
|
|
|
|
|
|
|
| Deletes the current email using the current protocol (POP3, IMAP, MS Exchange, Lotus Notes or Outlook).
|
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| Version 2026 includes new and improved functions, properties and data types, ... |
|
|
|
|
|
|
|
| Writes a cookie onto the computer of the Web user. |
|
|
|
|
|
|
|
| WINDEV enables you to handle an OLE control by programming... |
|
|
|
|
|
|
|
| The Language property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item). |
|
|
|
|
|
|
|
| A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view... |
|
|
|
|
|
|
|
| The CtUserName property sets the username used to connect to a specific table via OLE DB. |
|
|
|
|
|
|
|
| Returns the number of the help context associated with the specified control. |
|
|
|
|
|
|
|
Adds an "invisible" value to an element of a List or Combo Box control.Function kept for compatibility. It is recommended to use gStoredValue. |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
How to manage the synchronization between:- the page displayed in the browser. This page contains a RepeatString Looper control displaying records from an HFSQL data file.
- the corresponding page context found on the server.
|
|
|
|
|
|
|
|
| Used to enumerate the subelements of a project element. |
|
|
|
|
|
|
|
| Returns the characteristics of binary and text memos. |
|
|
|
|
|
|
|
| The Size property is used to determine and change the size of an element.
|
|
|
|
|
|
|
|
| Identifies the control hovered over with the mouse cursor. |
|
|
|
|
|
|
|
| Usage example of the SQLConnect function |
|
|
|
|
|
|
|
| Returns specific information about a Bluetooth radio connected to the computer. |
|
|
|
|
|
|
|
| Adds an element to a List Box, ListView or Combo Box control populated programmatically. |
|
|
|
|
|
|
|
| The report editor can be used to create form reports, which include different controls allowing users to enter data... |
|
|
|
|
|
|