Difference between revisions of "TABLEMETADATA()"

Revision as of 13:35, 16 February 2016

Purpose

Function to return the METADATA string from the Active Data Dictionary associated with the active table

Syntax

TABLEMETADATA()

See Also

ACLASS(), ADDPROPERTY(), AMEMBERS(), COLUMNMETADATA(), COMPOBJ(), CREATEOBJECT(), DEFINE CLASS, DISPLAY CLASSES, DODEFAULT(), FOREACH, JSON_DECODE(), JSON_DECODE_FILE(), JSON_ENCODE(), LIST CLASSES, LOADOBJECT(), METADATA_DECODE(), METADATA_ENCODE(), METADATA_FINDTYPE(), NEWOBJECT(), OBJECT(), PRINT_JSON(), PRINT_HTML(), PRINT_R(), PRINT_XML(), REMOVEPROPERTY(), REQUIRE_ONCE(), SAVEOBJECT(), SQL SELECT, SOCKET_CLOSE(), SOCKET_LASTERROR(), SOCKET_OPEN(), SOCKET_PEEK(), SOCKET_READ(), SOCKET_SERVER(), SOCKET_WRITE(), WITH, XML_DECODE_FILE()

Description

The TABLEMETADATA() function is used to return the METADATA string from the Active Data Dictionary associated with the active table. This can be a JSON encoded complex object containing properties that are arrays of objects or nested objects. You can change the elements of the metadata object then update the Active Data Dictionary with the new metadata.

Example

open database southwind
use customers
omd = json_decode( tableMetaData() )
omd.searchpanelvisible = .t.
use
alter table customers metadata json_encode(omd)