ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

SQLTable (Function)
Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows).
Step 1: Choosing the deployment profile
The setup program creation wizard allows you to select the deployment profile to use......
Operations in a Select query : add and delete
The following paragraphs present......
SQLTransaction (Function)
Begins, commits or rolls back a transaction: on the files of a database opened by SQLConnect, on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection....
SQLLock (Function)
Used to lock: The entire data table, in read and write mode. Its data cannot be accessed by other computers. The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example....
SQLColumn (Function)
Returns the characteristics of all the columns (or items): for a given table. for a given query....
EmailReadLastHeader (Function)
Reads the header of the last Email received, depending on the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadFirstHeader (Function)
Reads the header of the first incoming email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
EmailReadPreviousHeader (Function)
Reads the header of the email found before the current email according to the protocol used (POP3 or IMAP, Lotus Notes or Outlook).
Accessing a database in local mode (SQLite)
WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code....
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
SQLColumnFormat (Function)
Returns the different types of columns supported: by the data source identified by SQLConnect by the database accessed by a specific connection (connection described in the analysis or described by HDescribeConnection or HOpenConnection)....
SQLClose (Function)
Declares the end of the query execution and frees the memory resources allocated during the execution of the query.