COLUMNMETADATA()

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

Jump to: navigation, search

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] => @!
)