ICommenceDatabaseGetFields Method (String, String, Object, String)

Gets values of specified field(s) from specified item.

Namespace: Vovin.CmcLibNet.Database
Assembly: Vovin.CmcLibNet (in Vovin.CmcLibNet.dll) Version: 1.0.7729.42686

Syntax

string GetFields(
	string categoryName,
	string itemName,
	Object[] fields,
	string delim = null
)

Function GetFields ( 
	categoryName As String,
	itemName As String,
	fields As Object(),
	Optional delim As String = Nothing
) As String

Parameters

categoryName: Type: SystemString
Commence category name.
itemName: Type: SystemString
Commence item name.
fields: Type: SystemObject
object array containing fieldnames. .Net consumers can simply supply a string[], from VBScript/VBA and such use Array(field1, field2,...fieldN)
delim (Optional): Type: SystemString
Delimiter, up to 8 chars.

Return Value

Type: String
String with the fieldvalues of requested fields delimited by delim or CR/LF if delim not supplied.

Remarks

This method may prove a little problematic. It takes a list of fieldnames; because we do not know in advance what fields will be specified, you have to pass in an array as parameter, however, for this to work from COM, this array has to be of type 'object'. Note that this function is obsolete in the sense that this can be done much faster using CommenceQueryRowSet It can be useful however for getting fieldvalues of the active item. sample usage from VBA:

Copy

GetFields("categoryName", "itemName", Array(fieldname1, fieldname2,..., fieldnameN))

Reference

ICommenceDatabase Interface

GetFields Overload

Vovin.CmcLibNet.Database Namespace

ICommenceDatabaseAddLanguageSpecificTextSet("LST23A29416_0?cpp=::|nu=.");GetFields Method (String, String, AddLanguageSpecificTextSet("LST23A29416_1?cpp=array&lt;");ObjectAddLanguageSpecificTextSet("LST23A29416_2?cpp=&gt;|vb=()|nu=[]");, String)

Parameters

Return Value

Reference

ICommenceDatabaseGetFields Method (String, String, Object, String)