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 GetStringFieldData ( _ datasource As String, _ table As String, _ field_to_read As String, _ key As String, _ keyvalue As String, _ ByRef sResult As String, _ Optional login As String = "", _ Optional password As String = "" _ ) As Boolean

Visual Basic

Public Function GetStringFieldData ( _

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

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

public bool GetStringFieldData(

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

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

Visual C++

public:

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

JavaScript
function getStringFieldData(datasource, table, field_to_read, key, keyvalue, sResult, 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
result of the query as a string

Type: System.String
Optional. The login to access the datasource in an autheinticated 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