DbmsLibraryUniversalSubroutines < MasonSQL

Universal Methods and Subroutines

Method or Subroutine Name	Parameter Name	Valid Input Value or Attribute Value	Description	Default Value
`INFO`			Retrieves information from a `.mql` file and from a database table. It is cached in global hash `$Global{"ATTRS_<SCHEMA>_<TABLE>"}`
		`NAME`	The `INFO` method will retrieve all fields parameters or parameters of one field with parameter `NAME`. See also FIELDS method.
		`TYPE`	Data type of the field (`integer`, `float`, ...) The parameter limits the response to the requested type of query.
		`SIZE`	The field size in digits.
		`DECIMAL`	Decimal size of the field.
		`NOTNULL`	The field is not null-able; See also FIELDS_NOT_NULL method.
		`PRIMARY_KEY`	The field is a primary key.
		`DESCR`	Use description from the FIELDS_DESCR method.
		`FIND_DESCR`	Use description from FIND_FIELDS_DESCR method.
		`HIDDEN`	The field is not visible. Non-visible fields are defined with FIELDS_HIDDEN method.
`List2Array()`			Converts an input string into an array using input separator.
	`$list`		Input string.

`Find_Component()`			Returns the name of the component to be used in the search field. It first seeks for _FIND_FIELD, _FIND_ALIAS, _ALIAS, _FIELD methods.	If component is not found it returns `BOOL_FIND_FIELD` or `STANDARD_FIELD`.
	`$sep`		Input separator.	The default separator is `,`

Versione pagina: r9 - 22 Apr 2018, GuidoBrugnara