Difference between revisions of "PropertyListBox.LoadFromRecordSet"

From Jeremie Leroy - XOJO Controls Wiki
Jump to: navigation, search
 
m (1 revision imported)
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:
 
| parameters=RS As RecordSet, IDField As Integer = 1, DisplayID As Boolean = False, DefaultType As Integer = 0
 
| parameters=RS As RecordSet, IDField As Integer = 1, DisplayID As Boolean = False, DefaultType As Integer = 0
 
| returntype=Boolean
 
| returntype=Boolean
| version=1.6.0
+
| version=1.8
 
| platform=all
 
| platform=all
 
}}
 
}}
Line 13: Line 13:
  
 
This method is used to load a RecordSet to "populate" the Listbox.
 
This method is used to load a RecordSet to "populate" the Listbox.
 +
An example of XML definition is available in the Notes sections of the PropertyListBox.
  
The fi''RS''t row of the RecordSet is displayed. Field names go in the first column and field values go in the second value of the Listbox.
+
Optional parameter '''keepValues'''. Default is False.
 
+
If the Listbox already contained a data set, and the new data set is quite similar, you can try to keep the previous values with the '''keepValues''' property.
IDField is the nth Field of the RecordSet that represents the ID or Primary key in the RecordSet.
+
 
+
If'' DisplayID'' is set to True, the ID will be displayed in the Listbox.
+
 
+
DefaultType is the default LineType you want to apply to VARCHAR and TEXT fields.
+

Latest revision as of 17:27, 9 October 2015

Method
PropertyListBox.LoadFromRecordSet ( RS As RecordSet, IDField As Integer = 1, DisplayID As Boolean = False, DefaultType As Integer = 0 ) As Boolean


This method is used to load a RecordSet to "populate" the Listbox. An example of XML definition is available in the Notes sections of the PropertyListBox.

Optional parameter keepValues. Default is False. If the Listbox already contained a data set, and the new data set is quite similar, you can try to keep the previous values with the keepValues property.