Difference between revisions of "ODATA UPDATE()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 7: | Line 7: | ||
==See Also== | ==See Also== | ||
− | [[APPEND BLANK]], [[APPEND FROM]], [[APPEND FROM ARRAY]], [[DELETE|DELETE (NoSQL)]], [[SQL DELETE|DELETE (SQL)]], [[INSERT]], [[JSON_DECODE()]], [[JSON_DECODE_FILE()]], [[JSON_ENCODE()]], [[OData Operators]], [[ODATA_CREATE()]], [[ODATA_DELETE()]], [[ODATA_READ()]], [[PRINT_JSON()]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | + | [[APPEND BLANK]], [[APPEND FROM]], [[APPEND FROM ARRAY]], [[DELETE|DELETE (NoSQL)]], [[SQL DELETE|DELETE (SQL)]], [[INSERT]], [[JSON_DECODE()]], [[JSON_DECODE_FILE()]], [[JSON_ENCODE()]], [[OData Operators]], [[OData URIs]], [[ODATA_CREATE()]], [[ODATA_DELETE()]], [[ODATA_READ()]], [[PRINT_JSON()]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] |
==Description== | ==Description== |
Revision as of 09:33, 1 February 2017
Under Construction
Contents
Purpose
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.
Example
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") 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")