ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / SQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Modifies the content of a row in the query result.
Note The function SQLModify function allows you to modify the line stored in memory without having to re-execute the initial query to retrieve the result of the initial query. This function must be used during an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse.
SQLModify("REQSELECT", SQL.Current, NumClient + TAB + "34000" + TAB + Ville)
Syntax
SQLModify(<Query name> , <Row number> , <Row value>)
<Query name>: Character string
Name of the query created and executed with SQLExec, or executed with SQLExecWDR.
Java The queries created in the query editor must be specified in the format of a character string.
<Row number>: Integer
Number of the query row to update.
<Row value>: Character string
New row value. If the row 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 as a parameter is modified in the memory table associated with the query, for the row specified.
  • To modify the table of the connected database, an UPDATE query must be executed with SQLExec.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help