PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
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 line in the query result.
Note: SQLModify is used to modify the line stored in memory without having to re-run the initial query to retrieve the result of initial query. This function must be used during a SQLFirst/SQLCol browse of query result. See Types of SQL browse for more details.
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 the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the 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 the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the 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 the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the 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> , <Line Number> , <Line 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).
Java The queries created in the query editor must be specified in the format of a character string with quotes.
<Line Number>: Integer
Number of the query line to update.
<Line 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 line.
  • To modify the table of connected database, an UPDATE query must be run by SQLExec.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
See also
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment