ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

SQLClose (Function)
Declares the end of the query execution and frees the memory resources allocated during the execution of the query.
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)....
SQLSeek (Function)
Positions on the specified result row of the query.
SQLModify (Function)
Modifies the content of a row in the query result.
SQLListTable (Function)
List all the tables that can be accessed by the connected database system.
Native Sybase Connector: Specific features and remarks
The following paragraphs present the main aspects and specific features of the Native Sybase Connector (also called Native Sybase Access)......
Prototype overload/Overload
The procedures and the methods of classes can have several syntaxes....
SQLReqExists (Function)
Checks the existence of a query.
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLFetch (Function)
Goes to the next row (i.e next record) of the query result.
SQLAssociate (Function)
Automatically associates each column of the query result with a control or with a variable of the application.
Optional connection information
When defining the connections in the data model editor or when defining the connections through programming, you have the ability to specifier the optional connection information......
SQLChangeConnection (Function)
Modifies the current connection.
SQLDisconnect (Function)
Closes the current connection and frees the memory used by the connection.
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time......
Deploying a Java archive
Like for any application, WINDEV allows you to create a setup program for a Java application......
SQLListSource (Function)
Lists the data sources declared on a local site.
DateToWeekNumber (Function)
Returns the week number within the year that corresponds to the specified date.
SQLNext (Function)
Positions on the next row of the query result.
SQLPrevious (Function)
Positions on the previous row of the query result.
SQLFirst (Function)
Positions on the first row of the query result.
SQLGetMemo (Function)
Retrieves the content of a Memo column from the query result, for the current row.
Managing databases in the WINDEV Java applications
This document presents the different access modes to databases from a WINDEV Java application......
SQLLast (Function)
Sets the position on the last row of the query result.