SetProperty Method for LCConnection
This method assigns the value for a connection property.
Defined In
LCConnection
Syntax
Call thisConnection.SetProperty (propertyToken, srcField)
Parameters
Parameter |
Description |
---|---|
propertyToken |
Long. Token representing the connector property for which the value is to be assigned. See Appendix B for a list of tokens. |
srcField |
LCField. New value for the connector property. If the property value is of a different type than this field, then data conversion will occur. The property value will be assigned from the first value in the field. |
Usage Notes®
It's more efficient, as well as easier, to use the dynamic properties, for example:
thisConnection.Metadata = "adm1.customers"
The SetProperty syntax is useful if the information you need is already in LCField objects, or if you don't know what properties you'll set at the time you write the program.
Example
Option Public
Uselsx "*lsxlc"
Sub Initialize
Dim connect As New LCConnection ("oracle")
Dim conFld As New LCField (LCTYPE_TEXT, 1)
' set appropriate properties to connect to oracle
conFld.text = "Barker"
Call connect.SetProperty (LCTOKEN_SERVER, conFld)
' example of using the expanded property
Print "Here is the server property value: " & connect.Server
End Sub
Example Output
Here is the server property value: Barker