Programming Mechworks PDM > .NET API > MwPDMApi Namespace > Database Class > Database Methods

Given a keyName/KeyValue, it fetches from the required table the value of an assigned field

Namespace: MwPDMApi
Assembly: MwPDMApi (in MwPDMApi.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

Visual Basic
Public Function QueryTableFieldByKey ( _ tableName As String, _ keyName As String, _ keyValue As String, _ fieldName As String _ ) As String

Visual Basic

Public Function QueryTableFieldByKey ( _

tableName As String, _
keyName As String, _
keyValue As String, _
fieldName As String _
) As String

C#
public string QueryTableFieldByKey( string tableName, string keyName, string keyValue, string fieldName )

public string QueryTableFieldByKey(

string tableName,
string keyName,
string keyValue,
string fieldName
)

Visual C++
public: String^ QueryTableFieldByKey( String^ tableName, String^ keyName, String^ keyValue, String^ fieldName )

Visual C++

public:

String^ QueryTableFieldByKey(
String^ tableName,
String^ keyName,
String^ keyValue,
String^ fieldName
)

JavaScript
function queryTableFieldByKey(tableName, keyName, keyValue, fieldName);

Parameters

tableName

Type: System.String
table name identifier

keyName

Type: System.String
key name of the required table

keyValue

Type: System.String
key value to identify the requested field

fieldName

Type: System.String
field name identifier, to fetch the value

Return Value

fetched query value

Remarks