Difference between revisions of "COLUMNMETADATA()"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 9: | Line 9: | ||
==Description== | ==Description== | ||
− | The COLUMNMETADATA() function is used to return the METADATA string from the Active Data Dictionary associated with the specified column in the active table | + | The COLUMNMETADATA() function is used to return the METADATA string from the Active Data Dictionary associated with the specified column in the active table. |
==Example== | ==Example== | ||
Line 18: | Line 18: | ||
omd.caption = "Customer Name" | omd.caption = "Customer Name" | ||
omd.searchfield = .t. | omd.searchfield = .t. | ||
− | alter table customers modify constraint companyname metadata | + | alter table customers modify constraint companyname metadata metadata_encode(omd) |
use customers | use customers | ||
− | omd = | + | omd = metadata_decode(columnMetaData("companyname")) |
omd.caption = "Customer" | omd.caption = "Customer" | ||
omd.picture = "@!" | omd.picture = "@!" | ||
omd.searchfield = .t. | omd.searchfield = .t. | ||
− | alter table customers modify constraint companyname metadata | + | alter table customers modify constraint companyname metadata metadata_encode(omd) |
− | ? | + | ? metadata_decode(columnMetaData("companyname")) |
Revision as of 10:45, 27 February 2017
Contents
Purpose
Function to return the METADATA string from the Active Data Dictionary associated with the specified column in the active table
Syntax
COLUMNMETADATA(<expC1>)
See Also
ACLASS(), ADDPROPERTY(), AMEMBERS(), 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(), TABLEMETADATA(), TABLEMETADATAVERSION(), WITH, XML_DECODE_FILE()
Description
The COLUMNMETADATA() function is used to return the METADATA string from the Active Data Dictionary associated with the specified column in the active table.
Example
open database southwind use customers omd = object() omd.caption = "Customer Name" omd.searchfield = .t. alter table customers modify constraint companyname metadata metadata_encode(omd) use customers omd = metadata_decode(columnMetaData("companyname")) omd.caption = "Customer" omd.picture = "@!" omd.searchfield = .t. alter table customers modify constraint companyname metadata metadata_encode(omd) ? metadata_decode(columnMetaData("companyname")) Object (refcnt=1) ( [caption] => Customer [searchfield] => True [picture] => @! )