Difference between revisions of "PropertyListBox.LoadFromRecordSet"

From Jeremie Leroy - XOJO Controls Wiki
Jump to: navigation, search
m (1 revision)
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 18: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.