ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HNbRec (Function)
Returns the number of records in an HFSQL file, query or view: active records, deleted records, etc.
<Source>.NbRec (Function)
Returns the number of records in an HFSQL file, query or view: active records, deleted records, etc.
HToItem (Function)
Assigns the specified value to an item of the current record.
<Source>.Delete (Function)
Deletes a record from a data file (query or view).
Class inheritance
The hierarchical organization in class and sub-class has allowed to create the notion of inheritance......
<Source>.ToItem (Function)
Assigns the specified value to an item of the current record.
9. Distributing "Reports and Queries"
4. HFSQL Classic
HFSQL Classic is the database format......
Native Oracle Connector: Running the same query several times
In some cases, it may be useful to run the same query multiple times while modifying one or more parameters......
Creating an insert query
An insert query (corresponding SQL statement......
How to create a patch?
fReportsAndQueriesDir (Function)
Returns: the full path of the directory for the custom reports and queries. This directory corresponds to the directory of the reports and queries visible by the user who created them. the full path of the directory for the shared reports and queries. This directory corresponds to the directory of the reports and queries visible by all the application users....
How to clone and use columns in a Table control?
In some cases, a Table control must be filled with an unknown number of columns (when creating the control)....
sfObject (Type of variable)
The sfObject type is used to describe a record of a SalesForce file...
HTriggerRecordBefore (Function)
Retrieves the value of the current record before the trigger(s) are executed.
<Source>.RetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
<Source>.ReadFirst (Function)
Sets the position on the first record according to a browse item.
<Source>.Previous (Function)
Positions on the previous file record according to a browse item.
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
<Kanban>.Save (Function)
Updates the record bound to the current card in the Kanban control.
KanbanSave (Function)
Updates the record bound to the current card in the Kanban control.
<Source>.ErrorModification (Function)
Returns the value of a record item when a modification conflict occurs..
iListNestedReports (Function)
Returns: the list of nested reports currently printed (reports run by iPrintReport in one of the processes of the report currently printed). the list of sequenced reports currently printed (iSequenceAdd)....
The tables in a report
In a report, a table includes a set of controls called "Table cells"......
SQL: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query......
What is a database?
A database is an organized collection of data for a particular purpose (e.g., manage orders)......
LooperSave (Function)
Validates the modification or addition of the record associated with the current row in the Looper control.