PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Positions on the next row of the query result. This row becomes the current row.
If controls or variables are associated with the columns of query result (SQLAssociate), the values found in the current row are automatically assigned to these elements.
In most cases, SQLNext is used in a read loop with SQLFirst.
Caution: This function must be used during an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse.
Example
ResSQL = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResSQL = True THEN
SQLFirst("QRY1")
WHILE NOT SQL.Out
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
SQLNext("QRY1")
END
ELSE
// SQLEXEC error
END
SQLClose("QRY1")
Syntax
SQLNext(<Query name>)
<Query name>: Character string
Query name:
Java The queries created in the query editor must be specified in the format of a character string.
Remarks
  • If the pointer is located outside the query file, the SQL.Out variable is set to True.
  • The SQL.Current variable contains the number of the current row.
Component: wd280hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment