|
|
|
|
|
SQLModify (Function) In french: SQLModifie 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. <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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|