PC SOFT

ONLINE HELP
 WINDEV, WEBDEV 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
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 an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse.
Versions 19 and later
Android Widget This function is now available in Android widget mode (accessing the external databases via a Webservice).
Android This function is now available for Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).
New in version 19
Android Widget This function is now available in Android widget mode (accessing the external databases via a Webservice).
Android This function is now available for Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).
Android Widget This function is now available in Android widget mode (accessing the external databases via a Webservice).
Android This function is now available for Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Example
SQLModify("SELECTQRY", SQL.Current, CustomerNum + TAB + "34000" + TAB + City)
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 parameter is modified in the memory table associated with the query, for the specified row.
  • To modify the table of the connected database, an UPDATE query must be executed with SQLExec.
Component: wd270hf.dll
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment