ODATA UPDATE()

From Lianjapedia
Revision as of 11:45, 1 February 2017 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

OData-compatible function to update records

Syntax

ODATA_UPDATE(<cURI>,<cJSONdatastring>)

See Also

APPEND BLANK, APPEND FROM, APPEND FROM ARRAY, DELETE (NoSQL), DELETE (SQL), INSERT, JSON_DECODE(), JSON_DECODE_FILE(), JSON_ENCODE(), OData Operators, OData URIs, ODATA_CREATE(), ODATA_DELETE(), ODATA_READ(), PRINT_JSON(), SELECT, UPDATE

Description

The ODATA_UPDATE() function is used to update records.

Parameter Required Description
<cURI> Yes The OData URI - see OData URIs for full details.
<cJSONdatastring> Yes JSON string containing the name/value pair(s) for the column(s) to be updated and the "__olddata" name containing the name/value pair(s) to identify the record(s) to be updated.

Example

// All records that match the name/value pairs in __olddata will be updated
// Here all the order_details records with an orderid of 10951
// will have their discount field set to 6
cUpdateString = '{"discount":6, "__olddata":{"orderid":10951}}'
odata_update("/southwind/order_details",cUpdateString)
 
// OData-compatible functions
odata_read("/southwind/shippers")
odata_read("/southwind/shippers","readresults.txt")
? filetostr("readresults.txt")
 
cCreateString = '{"shipperid":4,"companyname":"Acme Inc.","phone":"(503) 555-1234"}'
odata_create("/southwind/shippers",cCreateString)
odata_read("/southwind/shippers")
 
// Specify a unique name/value pair identifier to update an individual record
cUpdateString = '{"phone":"(503) 555-5678", "__olddata":{"shipperid":4}}'
odata_update("/southwind/shippers",cUpdateString)
odata_read("/southwind/shippers")
 
cDeleteString = '{"shipperid":4}'
odata_delete("/southwind/shippers",cDeleteString)
odata_read("/southwind/shippers")