For my first Blog post (well, I guess technically second), I’m going to keep things pretty simple. If you’re already familiar with implementing customizations in SalesLogix, this will all be old hat. If you’re familiar with common controls in Visual Basic or C#, then this should all seem familiar to you as well. I’ll get more in-depth in the future; but for now, here’s some of the most common controls I use in SalesLogix customizations.
Label: A simple label control. Set the caption property for the display value.
EditBox: This control is basically the same as the TextBox control in .Net. You simply need to bind the text property of the control to the appropriate field. The FormatType property holds a number of enumerated values which can be used to determine how the text in the control is displayed (Integer, DateTime, Currency, etc…)
Button: This is just like the button control in C# or Visual Basic. The OnClick event of the control contains the code launched when clicking the button.
CheckBox: The Checkbox control allows a user to select or clear the associated option. Set the text property of the control to bind to a database field. Use the caption property to label the control.
ComboBox: The combo box functions almost exactly like the EditBox control, with the exception of a with drop-down list of potential Values. These values can be defined either at design-time, using the Items property, or programmatically:
(As an example)
Set objRS = Application.CreateObject(“ADODB.Recordset”)
.LockType = adLockReadOnly
.Open “Select distinct field1 from testtable where 1=2”, Application.GetNewConnection
While not (.Bof or .Eof)
Set objRS = Nothing
As you can see, this is just VBScript, using
DataGrid: Displays rows/columns of SalesLogix data, typically used to display 1-to-many data in SalesLogix (think the Account:Contacts tab, or Account: Notes/History)
DateTimeEdit: This control allows a user to select a date and/or time value.
LookupEdit: The LookupEdit control is used to lookup data using a predefined lookup in SalesLogix.
PickList: The picklist control is used to display picklists as they are defined in the SalesLogix architect.
RadioGroup: This control allows a user to select one from a group of defined options. Options are defined using the control’s Items property. The caption property labels the group itself.
Hopefully, this gives you at least a basic idea of what controls are available for use in SLX (you can include other ActiveX controls as well, but that’ll be a topic for another time.) I’ll be going through each of the controls in depth in future posts.