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

Displays a selection box reading data from a database.

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

Syntax

Visual Basic
Public Function FilterSelect ( _ title As String, _ dsn As String, _ user As String, _ pwd As String, _ selectStatement As String, _ fieldToRead As String, _ fieldToFilterOn As String, _ ByRef multipleResult As Object, _ Optional filterValue As String = "", _ Optional position As Integer = 1 _ ) As String

Visual Basic

Public Function FilterSelect ( _

title As String, _
dsn As String, _
user As String, _
pwd As String, _
selectStatement As String, _
fieldToRead As String, _
fieldToFilterOn As String, _
ByRef multipleResult As Object, _
Optional filterValue As String = "", _
Optional position As Integer = 1 _
) As String

C#
public string FilterSelect( string title, string dsn, string user, string pwd, string selectStatement, string fieldToRead, string fieldToFilterOn, ref Object multipleResult, string filterValue = "", int position = 1 )

public string FilterSelect(

string title,
string dsn,
string user,
string pwd,
string selectStatement,
string fieldToRead,
string fieldToFilterOn,
ref Object multipleResult,
string filterValue = "",
int position = 1
)

Visual C++
public: String^ FilterSelect( String^ title, String^ dsn, String^ user, String^ pwd, String^ selectStatement, String^ fieldToRead, String^ fieldToFilterOn, Object^% multipleResult, String^ filterValue = L"", int position = 1 )

Visual C++

public:

String^ FilterSelect(
String^ title,
String^ dsn,
String^ user,
String^ pwd,
String^ selectStatement,
String^ fieldToRead,
String^ fieldToFilterOn,
Object^% multipleResult,
String^ filterValue = L"",
int position = 1
)

JavaScript
function filterSelect(title, dsn, user, pwd, selectStatement, fieldToRead, fieldToFilterOn, multipleResult, filterValue, position);

Parameters

title

Type: System.String
title for the dialog box

dsn

Type: System.String
data source name

user

Type: System.String
login

pwd

Type: System.String
password for the above login

selectStatement

Type: System.String
SQL SELECT statement for the data

fieldToRead

Type: System.String
name of the field to be read

fieldToFilterOn

Type: System.String
name of the field on which apply the filter when inputting characters in the edit box

multipleResult

Type: System.Object
Output. The array of Field_to_Read values in the filtered records

filterValue (Optional)

Type: System.String
Optional. The initial value for the filter that appears in the text box

position (Optional)

Type: System.Int32
Optional. 0- center of the scrren, 1- top left corner of the screen, 2- in the current mouse pointer position

Return Value

empty string if nothing has been selected or the first selected item

Remarks