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
Modifies the content of a row in the query result.
Remark: SQLModify modifies the row stored in memory without having to re-run the initial query to retrieve the result of the initial query. This function must be used during a SQLFirst/SQLCol browse of query result. See Types of SQL browse for more details.
SQLModify("SELECTQRY", SQL.Current, CustomerNum + TAB + "34000" + TAB + City)
Syntax
SQLModify(<Query name> , <Row number> , <Row value>)
<Query name>: Character string (with or without quotes)
Name of query created and run by SQLExec (with quotes), or run by SQLExecWDR (with or without quotes).
<Row number>: Integer
Number of the query row to update.
<Row value>: Character string (with quotes)
New value for the line. If the line contains several elements, the values are separated by TAB characters.
Remarks
  • SQLModify does not modify the table content but the content of query result found in memory.
  • The value passed in parameter is modified in the memory table associated with the query, for the specified row.
  • To modify the table of connected database, an UPDATE query must be run by SQLExec.
Component : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment