1. Home / Web Services API Version 7.5 / SetPropertySetLookupFieldParametersForMYSQL

SetPropertySetLookupFieldParametersForMYSQL

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

Syntax

Visual Basic (declaration) 
Public Function SetPropertySetLookupFieldParametersForMYSQL( _ 
	ByVal AuthenticationTicket as String, _ 
	ByVal PropertySetName as String, _ 
	ByVal FieldName as String, _ 
	ByVal MYSQL_ServerName as string , _ 
	ByVal MYSQL_PortNumber as string , _ 
	ByVal MYSQL_UserName as string , _ 
	ByVal MYSQL_Password as string , _ 
	ByVal MYSQL_DataBasename as string , _ 
	ByVal sqlSentence as String) as XmlNode

C# (declaration) 
public XmlNode SetPropertySetLookupFieldParametersForMYSQL( 
	string AuthenticationTicket,
	string PropertySetName,
	string FieldName,
	string  MYSQL_ServerName,
	string  MYSQL_PortNumber,
	string  MYSQL_UserName,
	string  MYSQL_Password,
	string  MYSQL_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.
MYSQL_ServerName
    string The name or IP address of the MYSQL server
MYSQL_PortNumber
    string The Port number that MYSQL server listening to.
MYSQL_UserName
    string The username that will be used while connecting to the MYSQL server
MYSQL_Password
    string The passwod of the user
MYSQL_DataBasename
    string The MYSQL 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