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

Queries a given table from a datasource for a string field through a key field and key value

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

Syntax

Visual Basic
Public Function GetStringFieldData2 ( _ datasource As String, _ table As String, _ field_to_read As String, _ key As String, _ keyvalue As String, _ ByRef sResult As String, _ ByRef isValueNull As Boolean, _ Optional login As String = "", _ Optional password As String = "" _ ) As Object

Visual Basic

Public Function GetStringFieldData2 ( _

datasource As String, _
table As String, _
field_to_read As String, _
key As String, _
keyvalue As String, _
ByRef sResult As String, _
ByRef isValueNull As Boolean, _
Optional login As String = "", _
Optional password As String = "" _
) As Object

C#
public Object GetStringFieldData2( string datasource, string table, string field_to_read, string key, string keyvalue, ref string sResult, ref bool isValueNull, string login = "", string password = "" )

public Object GetStringFieldData2(

string datasource,
string table,
string field_to_read,
string key,
string keyvalue,
ref string sResult,
ref bool isValueNull,
string login = "",
string password = ""
)

Visual C++
public: Object^ GetStringFieldData2( String^ datasource, String^ table, String^ field_to_read, String^ key, String^ keyvalue, String^% sResult, bool% isValueNull, String^ login = L"", String^ password = L"" )

Visual C++

public:

Object^ GetStringFieldData2(
String^ datasource,
String^ table,
String^ field_to_read,
String^ key,
String^ keyvalue,
String^% sResult,
bool% isValueNull,
String^ login = L"",
String^ password = L""
)

JavaScript
function getStringFieldData2(datasource, table, field_to_read, key, keyvalue, sResult, isValueNull, login, password);

Parameters

datasource

Type: System.String
name of a valid datasource or "@USEDEFAULTDATASOURCE" to force the usage of the default application datasource

table

Type: System.String
name of an existing table in the specified datasource.

field_to_read

Type: System.String
name of the field from which the value must be taken.

key

Type: System.String
field of which the value will be checked to determine the query selection.

keyvalue

Type: System.String
value that will be checked to determine which records to read.

sResult

Type: System.String
Output. result of the query as a string

isValueNull

Type: System.Boolean
Output. TRUE if the returned field value is NULL, FALSE otherwise

Type: System.String
Optional. The login to access the datasource in an authenticated way

password (Optional)

Type: System.String
Optional. The password related to the specified login.

Return Value

TRUE if the selection found any valid result, FALSE otherwise

Remarks