Initializing help system before first use

SQLupdate

Purpose
Update the selected data with the provided array(s).
Synopsis
procedure SQLupdate(s:string|text, a:array)
procedure SQLupdate(s:string|text, la:list)
Arguments
s 
An SQL `SELECT' command
a 
An array of one of the basic types (integer, real, string or Boolean)
la 
A list of arrays of basic types (integer, real string or Boolean)
Example
The following example initializes the array prices with the values of the table pricelist, changes some values in the array and finally, updates the date in the table pricelist. 
declarations
 prices: array(1001..1004) of real
end-declarations
SQLexecute("select articlenum,price from pricelist", prices)
prices(1002):=prices(1002)*0.9; prices(1003):=prices(1003)*0.8
SQLupdate("select articlenum,price from pricelist", prices)
Further information
This procedure updates the data selected by an SQL command (usually `SELECT') with an array or tuple of arrays. This procedure is available only if the data source supports positioned updates (for instance, MS Access does but MS Excel does not). An IO error will be raised if the required functionality is not available.
Related topics
SQLexecute.
Module
mmodbc

Parent Topic Procedures and functions

© 2001-2025 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.