PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Positions on the next line of query result. This line becomes the current line.
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 a SQLFirst/SQLCol browse of query result. See Types of SQL browse for more details.
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 (with or without quotes)
Query Name:
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 line.
Component : wd240hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment