Sets the parameters of the specified property set's lookup field. (SQLSERVER)

Syntax

Visual Basic (declaration)
Public Function SetPropertySetLookupFieldParametersForSQLServer( _ 
ByVal AuthenticationTicket as String, _ ByVal PropertySetName as String, _ ByVal FieldName as String, _ ByVal SQLSERVER_ServerName as string , _ ByVal SQLSERVER_UserName as string , _ ByVal SQLSERVER_Password as string , _ ByVal SQLSERVER_DataBasename as string , _ ByVal sqlSentence as String) as XmlNode

C# (declaration)
public XmlNode SetPropertySetLookupFieldParametersForSQLServer( 
string AuthenticationTicket, string PropertySetName, string FieldName, string SQLSERVER_ServerName, string SQLSERVER_UserName, string SQLSERVER_Password, string SQLSERVER_DataBasename, string sqlSentence)

Parameters

AuthenticationTicket
    string infoRouter ticket
PropertySetName
    string The property set name
FieldName
    string The Name of the field that the parameters will updated.
SQLSERVER_ServerName
    string The name or IP address of the SQLSERVER server
SQLSERVER_UserName
    string The username that will be used while connecting to the MSSQLSERVER
SQLSERVER_Password
    string The passwod of the user
SQLSERVER_DataBasename
    string The SQLSERVER database name
sqlSentence
    string SQL select sentence that will be used while retrieving lookup data.

Return Value

returns xml fragment.
<response success="true" error="">
if success = "true", the lookup parameters has been successfully applied.
if success = "false", the error attribute returns the error description.