1. Home / Web Services API Version 8.x / SetPropertySetLookupFieldParametersForSQLServer

SetPropertySetLookupFieldParametersForSQLServer

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.

See Also