Click or drag to resize

ISelectionForeignKey Property

ForeignKey Get the foreign key values for this selection

Namespace:  SuperOffice.COM.SuperOfficeDB
Assembly:  SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
Syntax
SOForeignKey ForeignKey { get; }

Property Value

Type: SOForeignKey
SOForeignKey
Examples

ForeginKey

This text may be copied to the notepad, and saved as a *.vbs file. Remember to change the login information.

Search the contact table for the first record that has an OrgNr that starts with 979& Returns a message box with the Contact name.

VB
Dim objSO
Set objSO = CreateObject("SuperOfficeDB.Database")
Set objSOApp = CreateObject("SuperOffice.Application")
If not (objSO is nothing) Then
    objSO.Login "<userID>", "<password>"
    if objSOApp.currentSelection.Identity <> 0 then
        set mySelection = objSo.GetSelection(objSOApp.CurrentSelection.Identity)
        mySelection.ForeignKey.Set "MyApplication", "MyDevice", "MyKey", "This is my foreignKey"
        MsgBox mySelection.Name & " has the following foreginKey set: " & mySelection.ForeignKey.Get ("MyApplication", "MyDevice", "MyKey")
    else
        msgbox "Mark a Selection and try again"      
    end if
else
          MsgBox "Unable to connect to database"
end if
Set objSO = Nothing

See Also