SQLupdate
SQLupdate |
Purpose
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).
Related topics
Module