8/23/2025 9:29:05 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Populating a pick list at run time
Posted: 18 Mar 08 9:05 AM
|
I need to populate a picklist at run time based upon the value of another field on the screen. The reason I chose a picklist is because the user must be able to choose multiple items. When I do the following:
Set objPickList = Application.PickLists.Item("Dummy")
Set objDatabaseRS = objSLXDB.GetNewRecordSet
sSQL = "select products from mktg_program where mktg_programid = '" & edtMktgProgramID.Text & "'"
objDatabaseRS.Open sSQL, objSLXDB.Connection
If Not objDatabaseRs.EOF Then
If Not IsNull(objDatabaseRS.Fields(0).Value) Then sProducts = objDatabaseRS.Fields(0).Value
End If
arrayProducts = Split(sProducts,",")
For i = LBound(arrayProducts) to UBound(arrayProducts)
objPickList.Add arrayProducts(i),""
Next
The values that are added to the picklist, Dummy, with objPickList.Add arrayProducts(i),"" are being written to the database. Dummy is an empty picklist that I set up in Architect (Manage-->PickLists). Is there a way that I can prevent the values from being written to the database? I guess I could just delete them with a sql but that may cause some issues if 2 users happened to be using the picklist at the same time. |
|
|
| |
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|