500:
How can I filter items for dates before a specified date

with thisform.Tree1
	.BeginUpdate
	with .Columns.Add("Dates")
		.SortType = 2
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .T.
		.DisplayFilterDate = .T.
		.FilterList = 1026 && FilterListEnum.exShowFocusItem Or FilterListEnum.exNoItems
		.Filter = "to 12/27/2010"
		.FilterType = 4
	endwith
	with .Items
		.AddItem({^2010-12-27})
		.AddItem({^2010-12-28})
		.AddItem({^2010-12-29})
		.AddItem({^2010-12-30})
		.AddItem({^2010-12-31})
	endwith
	.ApplyFilter
	.EndUpdate
endwith
499:
Is it possible to filter dates

with thisform.Tree1
	.BeginUpdate
	with .Columns.Add("Dates")
		.SortType = 2
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .T.
		.DisplayFilterDate = .T.
		.FilterList = 1026 && FilterListEnum.exShowFocusItem Or FilterListEnum.exNoItems
	endwith
	with .Items
		.AddItem({^2010-12-27})
		.AddItem({^2010-12-28})
		.AddItem({^2010-12-29})
		.AddItem({^2010-12-30})
		.AddItem({^2010-12-31})
	endwith
	.EndUpdate
endwith
498:
Is it possible to change the Exclude field name to something different, in the drop down filter window

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Object.Description(25) = "Leaving out"
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 9472 && FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
	endwith
	.EndUpdate
endwith
497:
How can I display the Exclude field in the drop down filter window

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 9472 && FilterListEnum.exShowExclude Or FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
	endwith
	.EndUpdate
endwith
496:
Is it possible to show and ensure the focused item from the control, in the drop down filter window

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 1280 && FilterListEnum.exShowFocusItem Or FilterListEnum.exShowCheckBox
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.DefaultItem = .InsertItem(h,Null,"Child 2")
		.SelectItem(0) = .T.
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	.EndUpdate
endwith
495:
Is it possible to show only blanks items with no listed items from the control

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 16386 && FilterListEnum.exShowBlanks Or FilterListEnum.exNoItems
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.EndUpdate
endwith
494:
How can I include the blanks items in the drop down filter window

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 16640 && FilterListEnum.exShowBlanks Or FilterListEnum.exShowCheckBox
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.EndUpdate
endwith
493:
How can I select multiple items in the drop down filter window, using check-boxes

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 256
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.EndUpdate
endwith
492:
Is it possible to allow a single item being selected in the drop down filter window

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .F.
		.FilterList = 128
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.EndUpdate
endwith
491:
How can I display no (All) item in the drop down filter window

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Object.Description(0) = ""
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .T.
		.FilterList = 2
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.EndUpdate
endwith
490:
Is it possible to display no items in the drop down filter window, so only the pattern is visible

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	with .Columns.Add("Items")
		.DisplayFilterButton = .T.
		.DisplayFilterPattern = .T.
		.FilterList = 2
	endwith
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.EndUpdate
endwith
489:
How do I hide the selection

with thisform.Tree1
	.BeginUpdate
	.MarkSearchColumn = .F.
	.SelForeColor = .ForeColor
	.SelBackColor = .BackColor
	.ShowFocusRect = .F.
	with .Columns
		with .Add("Format")
			var_s = "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=000"
			var_s = var_s + "0FF>+'+(value format '2|.|3|,' ): '0.00') )"
			.FormatColumn = var_s
			.Def(17) = 1
		endwith
	endwith
	with .Items
		.AddItem(10)
		.AddItem(-8)
	endwith
	.EndUpdate
endwith
488:
How do I access the cells, or how do I get the values in the columns
with thisform.Tree1
	with .Columns
		.Add("C1")
		.Add("C2")
		.Add("C3")
	endwith
	with .Items
		h = .AddItem("Item 1")
		.DefaultItem = h
		.CellCaption(0,1) = "SubItem 1.1"
		.DefaultItem = h
		.CellCaption(0,2) = "SubItem 1.2"
		DEBUGOUT( .CellCaption(h,0) )
	endwith
endwith
487:
Is it possible to load child items when clicking the +/- button

*** BeforeExpandItem event - Fired before an item is about to be expanded (collapsed). ***
LPARAMETERS Item,Cancel
	with thisform.Tree1
		with .Items
			.InsertItem(Item,Null,"new")
			.DefaultItem = .InsertItem(Item,Null,"new")
			.ItemHasChildren(0) = .T.
			.InsertItem(Item,Null,"new")
		endwith
	endwith

with thisform.Tree1
	.LinesAtRoot = -1
	.Columns.Add("Default")
	with .Items
		.DefaultItem = .AddItem("aka")
		.ItemHasChildren(0) = .T.
		.AddItem("next item")
	endwith
endwith
486:
How can I change the check-boxes appearance

with thisform.Tree1
	.LinesAtRoot = -1
	with .Columns.Add("Default")
		.Def(0) = .T.
		.PartialCheck = .T.
	endwith
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	with .VisualAppearance
		.Add(1,"XP:Button 3 12")
		.Add(2,"XP:Button 3 11")
		.Add(3,"XP:Button 3 10")
	endwith
	.Object.CheckImage(0) = 16777216
	.Object.CheckImage(1) = 33554432
	.Object.CheckImage(2) = 50331648
endwith
485:
How can I initiate the OLE Drag and Drop support

*** OLEStartDrag event - Occurs when the OLEDrag method is called. ***
LPARAMETERS Data,AllowedEffects
	*** Data.SetData("data to drag")
	with thisform.Tree1
		AllowedEffects = 1
	endwith

with thisform.Tree1
	.OLEDropMode = 1
	.LinesAtRoot = -1
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
484:
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)

with thisform.Tree1
	.BeginUpdate
	with .ConditionalFormats.Add("1","K1")
		.BackColor = RGB(255,0,0)
		.ApplyTo = 1 && 0x1
	endwith
	with .ConditionalFormats.Add("1","K2")
		.BackColor = RGB(255,0,0)
		.ApplyTo = 2 && 0x2
	endwith
	.MarkSearchColumn = .F.
	.DrawGridLines = -2
	with .Columns
		.Add("Column 1")
		.Add("Column 2")
		.Add("Column 3")
	endwith
	with .Items
		.AddItem()
		.AddItem()
		.AddItem()
	endwith
	.EndUpdate
endwith
483:
Is it possible to display empty strings for 0 values

with thisform.Tree1
	.Columns.Add("Currency").FormatColumn = "dbl(value) ? currency(dbl(value)) : ``"
	with .Items
		.AddItem(1.23)
		.AddItem(2.34)
		.AddItem(0)
		.AddItem(10000.99)
	endwith
endwith
482:
Is it possible to display empty strings for 0 values

with thisform.Tree1
	.Columns.Add("Number")
	.Columns.Add("Currency").ComputedField = "%0 ? currency(%0) : ``"
	with .Items
		.AddItem(1.23)
		.AddItem(2.34)
		.AddItem(0)
		.AddItem(10000.99)
	endwith
endwith
481:
How can I get the list of items as they are displayed
with thisform.Tree1
	.BeginUpdate
	.BackColorAlternate = RGB(240,240,240)
	.Columns.Add("Names")
	with .Items
		.AddItem("Mantel")
		.AddItem("Mechanik")
		.AddItem("Motor")
		.AddItem("Murks")
		.AddItem("Märchen")
		.AddItem("Möhren")
		.AddItem("Mühle")
	endwith
	.Columns.Item(0).SortOrder = 1
	.EndUpdate
	DEBUGOUT( .GetItems(1) )
endwith
480:
Is posible to reduce the size of the picture to be shown in the column's caption

with thisform.Tree1
	.BeginUpdate
	.Object.HTMLPicture("pic1") = "c:\exontrol\images\zipdisk.gif"
	.HeaderHeight = 48
	.Columns.Add("DefaultSize").HTMLCaption = "Default-Size <img>pic1</img> Picture"
	.Columns.Add("CustomSize").HTMLCaption = "Custom-Size <img>pic1:16</img> Picture"
	.EndUpdate
endwith
479:
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column

with thisform.Tree1
	.BeginUpdate
	.MarkSearchColumn = .F.
	with .ConditionalFormats.Add("1")
		.Bold = .T.
		.ForeColor = RGB(255,0,0)
		.ApplyTo = 1 && 0x1
	endwith
	.Columns.Add("C1")
	with .Columns.Add("C2")
		.HeaderBold = .T.
		.HTMLCaption = "<fgcolor=FF0000>C2"
	endwith
	with .Items
		.DefaultItem = .AddItem(10)
		.CellCaption(0,1) = 11
		.DefaultItem = .AddItem(12)
		.CellCaption(0,1) = 13
	endwith
	.EndUpdate
endwith
478:
The item is not getting selected when clicking the cell's checkbox. What should I do

*** CellStateChanged event - Fired after cell's state has been changed. ***
LPARAMETERS Item,ColIndex
	with thisform.Tree1
		.DefaultItem = Item
		.Items.SelectItem(0) = .T.
	endwith

with thisform.Tree1
	.Columns.Add("Check").Def(0) = .T.
	with .Items
		.AddItem(0)
		.AddItem(1)
		.AddItem(2)
		.AddItem(3)
	endwith
endwith
477:
Is it possible to limit the height of the item while resizing

*** AddItem event - Occurs after a new Item has been inserted to Items collection. ***
LPARAMETERS Item
	with thisform.Tree1
		.DefaultItem = Item
		.Items.ItemMinHeight(0) = 18
		.DefaultItem = Item
		.Items.ItemMaxHeight(0) = 72
	endwith

with thisform.Tree1
	.BeginUpdate
	.ItemsAllowSizing = -1
	.ScrollBySingleLine = .F.
	.BackColorAlternate = RGB(240,240,240)
	.Columns.Add("Names")
	with .Items
		.AddItem("Mantel")
		.AddItem("Mechanik")
		.AddItem("Motor")
		.AddItem("Murks")
		.AddItem("Märchen")
		.AddItem("Möhren")
		.AddItem("Mühle")
	endwith
	.Columns.Item(0).SortOrder = 1
	.EndUpdate
endwith
476:
Is it possible to copy the hierarchy of the control using the GetItems method

with thisform.Tree1
	.LinesAtRoot = -1
	.Columns.Add("Def")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
	endwith
	.PutItems(.GetItems(-1))
endwith
475:
How can I show the child items with no identation

with thisform.Tree1
	.LinesAtRoot = 5
	.Indent = 12
	.HasLines = 2
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
	endwith
endwith
474:
Is there other ways of showing the hierarchy lines (exGroupLinesAtRoot)

with thisform.Tree1
	.LinesAtRoot = 1
	.Indent = 12
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
473:
Is there other ways of showing the hierarchy lines (exGroupLinesOutside)

with thisform.Tree1
	.LinesAtRoot = 5
	.Indent = 12
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
	endwith
endwith
472:
Is there other ways of showing the hierarchy lines (exGroupLinesInsideLeaf)

with thisform.Tree1
	.LinesAtRoot = 4
	.Indent = 12
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
471:
Is there other ways of showing the hierarchy lines (exGroupLinesInside)

with thisform.Tree1
	.LinesAtRoot = 3
	.Indent = 12
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
470:
Is there other ways of showing the hierarchy lines (exGroupLines)

with thisform.Tree1
	.LinesAtRoot = 2
	.Indent = 12
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(.InsertItem(h,Null,"Child 2"),Null,"SubChild 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
469:
Does your control supports multiple lines tooltip

with thisform.Tree1
	.Object.HTMLPicture("pic1") = "c:\exontrol\images\zipdisk.gif"
	.ToolTipDelay = 1
	var_s = "<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, i"
	var_s = var_s + "cons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>"
	.Columns.Add("tootip").ToolTip = var_s
endwith
468:
How can I prevent highlighting the column from the cursor - point

with thisform.Tree1
	var_s = "gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJg"
	var_s = var_s + "EgI="
	.VisualAppearance.Add(1,var_s)
	.Object.Background(32) = 0x1000000
	.Columns.Add("S").Width = 32
	.Columns.Add("Level 1").LevelKey = 1
	.Columns.Add("Level 2").LevelKey = 1
	.Columns.Add("Level 3").LevelKey = 1
	.Columns.Add("E1").Width = 32
	.Columns.Add("E2").Width = 32
	.Columns.Add("E3").Width = 32
	.Columns.Add("E4").Width = 32
endwith
467:
Is there any option to show the tooltip programmatically

*** MouseMove event - Occurs when the user moves the mouse. ***
LPARAMETERS Button,Shift,X,Y
	with thisform.Tree1
		.ShowToolTip(.ItemFromPoint(-1,-1,c,hit),"","8","8")
	endwith

with thisform.Tree1
	.BeginUpdate
	.Columns.Add("Def")
	with .Items
		.AddItem("Item 1")
		.AddItem("Item 2")
		.AddItem("Item 3")
	endwith
	.EndUpdate
endwith
466:
Is it possible to prevent changing the rows/items colors by selection

with thisform.Tree1
	.SelBackMode = 1
	.Columns.Add("HTML").Def(17) = 1
	with .Items
		.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.")
		.DefaultItem = .AddItem("<font ;6>This</font> <b>is</b> another <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.")
		.SelectItem(0) = .T.
	endwith
endwith
465:
Is it possible to specify the cell's value but still want to display some formatted text instead the value

with thisform.Tree1
	.BeginUpdate
	.MarkSearchColumn = .F.
	.Columns.Add("Value")
	.Columns.Add("FormatCell")
	with .Items
		h = .AddItem(1)
		.DefaultItem = h
		.CellCaption(0,1) = 12
		.DefaultItem = h
		.FormatCell(0,1) = "currency(value)"
		h = .AddItem({^2001-1-1})
		.DefaultItem = h
		.CellCaption(0,1) = {^2001-1-1}
		.DefaultItem = h
		.CellCaptionFormat(0,1) = 1
		.DefaultItem = h
		.FormatCell(0,1) = "longdate(value) replace '2001' with '<b>2001</b>'"
	endwith
	.EndUpdate
endwith
464:
How can I simulate displaying groups

with thisform.Tree1
	.BeginUpdate
	.HasLines = 0
	.ScrollBySingleLine = .T.
	.MarkSearchColumn = .F.
	with .Columns
		.Add("Name")
		.Add("A")
		.Add("B")
		.Add("C")
	endwith
	with .Items
		h = .AddItem("Group 1")
		.DefaultItem = h
		.CellHAlignment(0,0) = 1
		.DefaultItem = h
		.ItemDivider(0) = 0
		.DefaultItem = h
		.ItemDividerLineAlignment(0) = 3
		.DefaultItem = h
		.ItemHeight(0) = 24
		.DefaultItem = h
		.SortableItem(0) = .F.
		h1 = .InsertItem(h,Null,"Child 1")
		.DefaultItem = h1
		.CellCaption(0,1) = 1
		.DefaultItem = h1
		.CellCaption(0,2) = 2
		.DefaultItem = h1
		.CellCaption(0,3) = 3
		h1 = .InsertItem(h,Null,"Child 2")
		.DefaultItem = h1
		.CellCaption(0,1) = 4
		.DefaultItem = h1
		.CellCaption(0,2) = 5
		.DefaultItem = h1
		.CellCaption(0,3) = 6
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("Group 2")
		.DefaultItem = h
		.CellHAlignment(0,0) = 1
		.DefaultItem = h
		.ItemDivider(0) = 0
		.DefaultItem = h
		.ItemDividerLineAlignment(0) = 3
		.DefaultItem = h
		.ItemHeight(0) = 24
		.DefaultItem = h
		.SortableItem(0) = .F.
		h1 = .InsertItem(h,Null,"Child 1")
		.DefaultItem = h1
		.CellCaption(0,1) = 1
		.DefaultItem = h1
		.CellCaption(0,2) = 2
		.DefaultItem = h1
		.CellCaption(0,3) = 3
		h1 = .InsertItem(h,Null,"Child 2")
		.DefaultItem = h1
		.CellCaption(0,1) = 4
		.DefaultItem = h1
		.CellCaption(0,2) = 5
		.DefaultItem = h1
		.CellCaption(0,3) = 6
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	.EndUpdate
endwith
463:
How can I collapse all items

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("Items")
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.ExpandItem(0) = .F.
	endwith
	.EndUpdate
endwith
462:
How can I expand all items

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("Items")
	with .Items
		h = .AddItem("Root 1")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		h = .AddItem("Root 2")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.ExpandItem(0) = .T.
	endwith
	.EndUpdate
endwith
461:
Can I use PNG images to display pictures in the control

with thisform.Tree1
	.Object.HTMLPicture("pic1") = "c:\exontrol\images\card.png"
	.HeaderHeight = 48
	.Columns.Add("ColumnName").HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture"
endwith
460:
Is it possible to move an item from a parent to another

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("Items")
	with .Items
		.AddItem("A")
		.AddItem("B")
		.InsertItem(.AddItem("C"),"","D")
		.SetParent(.FindItem("D",0),.FindItem("A",0))
	endwith
	.EndUpdate
endwith
459:
How can I change the identation for an item

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("Items")
	with .Items
		.AddItem("A")
		.AddItem("B")
		.InsertItem(.AddItem("C"),"","D")
		.SetParent(.FindItem("D",0),0)
	endwith
	.EndUpdate
endwith
458:
How can I filter programatically using more columns

with thisform.Tree1
	.BeginUpdate
	.MarkSearchColumn = .F.
	with .Columns
		.Add("Car")
		.Add("Equipment")
	endwith
	with .Items
		.DefaultItem = .AddItem("Mazda")
		.CellCaption(0,1) = "Air Bag"
		.DefaultItem = .AddItem("Toyota")
		.CellCaption(0,1) = "Air Bag,Air condition"
		.DefaultItem = .AddItem("Ford")
		.CellCaption(0,1) = "Air condition"
		.DefaultItem = .AddItem("Nissan")
		.CellCaption(0,1) = "Air Bag,ABS,ESP"
		.DefaultItem = .AddItem("Mazda")
		.CellCaption(0,1) = "Air Bag, ABS,ESP"
		.DefaultItem = .AddItem("Mazda")
		.CellCaption(0,1) = "ABS,ESP"
	endwith
	with .Columns.Item("Car")
		.FilterType = 240
		.Filter = "Mazda"
	endwith
	with .Columns.Item("Equipment")
		.FilterType = 3
		.Filter = "*ABS*|*ESP*"
	endwith
	.ApplyFilter
	.EndUpdate
endwith
457:
Is it possible to colour a particular column, I mean the cell's foreground color

with thisform.Tree1
	.BeginUpdate
	with .ConditionalFormats.Add("1")
		.ForeColor = RGB(255,0,0)
		.ApplyTo = 1 && 0x1
	endwith
	.MarkSearchColumn = .F.
	with .Columns
		.Add("Column 1")
		.Add("Column 2")
	endwith
	with .Items
		.DefaultItem = .AddItem(0)
		.CellCaption(0,1) = 1
		.DefaultItem = .AddItem(2)
		.CellCaption(0,1) = 3
		.DefaultItem = .AddItem(4)
		.CellCaption(0,1) = 5
	endwith
	.EndUpdate
endwith
456:
Is it possible to colour a particular column for specified values

with thisform.Tree1
	.BeginUpdate
	with .ConditionalFormats.Add("int(%1) in (3,4,5)")
		.BackColor = RGB(255,0,0)
		.ApplyTo = 1 && 0x1
	endwith
	.MarkSearchColumn = .F.
	with .Columns
		.Add("Column 1")
		.Add("Column 2")
	endwith
	with .Items
		.DefaultItem = .AddItem(0)
		.CellCaption(0,1) = 1
		.DefaultItem = .AddItem(2)
		.CellCaption(0,1) = 3
		.DefaultItem = .AddItem(4)
		.CellCaption(0,1) = 5
	endwith
	.EndUpdate
endwith
455:
Is it possible to colour a particular column

with thisform.Tree1
	.BeginUpdate
	.MarkSearchColumn = .F.
	with .Columns
		.Add("Column 1")
		.Add("Column 2").Def(4) = 255
	endwith
	with .Items
		.DefaultItem = .AddItem(0)
		.CellCaption(0,1) = 1
		.DefaultItem = .AddItem(2)
		.CellCaption(0,1) = 3
		.DefaultItem = .AddItem(4)
		.CellCaption(0,1) = 5
	endwith
	.EndUpdate
endwith
454:
How do i get all the children items that are under a certain parent Item handle
with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("P")
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	with .Items
		hChild = .ItemChild(.FirstVisibleItem)
		DEBUGOUT( .CellCaption(hChild,0) )
		DEBUGOUT( .CellCaption(.NextSiblingItem(hChild),0) )
	endwith
	.EndUpdate
endwith
453:
How can I get the caption of focused item
*** SelectionChanged event - Fired after a new item has been selected. ***
LPARAMETERS nop
	with thisform.Tree1
		with .Items
			DEBUGOUT( "Handle" )
			DEBUGOUT( .FocusItem )
			DEBUGOUT( "Caption" )
			DEBUGOUT( .CellCaption(.FocusItem,0) )
		endwith
	endwith

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("Items")
	with .Items
		h = .AddItem("R1")
		.InsertItem(h,Null,"Cell 1.1")
		.InsertItem(h,Null,"Cell 1.2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("R2")
		.InsertItem(h,Null,"Cell 2.1")
		.InsertItem(h,Null,"Cell 2.2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	.EndUpdate
endwith
452:
How can I get the caption of selected item
*** SelectionChanged event - Fired after a new item has been selected. ***
LPARAMETERS nop
	with thisform.Tree1
		with .Items
			DEBUGOUT( "Handle" )
			DEBUGOUT( .SelectedItem(0) )
			DEBUGOUT( "Caption" )
			DEBUGOUT( .CellCaption(.SelectedItem(0),0) )
		endwith
	endwith

with thisform.Tree1
	.BeginUpdate
	.LinesAtRoot = -1
	.Columns.Add("Items")
	with .Items
		h = .AddItem("R1")
		.InsertItem(h,Null,"Cell 1.1")
		.InsertItem(h,Null,"Cell 1.2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
		h = .AddItem("R2")
		.InsertItem(h,Null,"Cell 2.1")
		.InsertItem(h,Null,"Cell 2.2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	.EndUpdate
endwith
451:
Can I display the cell's check box after the text

with thisform.Tree1
	with .Columns.Add("Column")
		.Def(0) = .T.
		.Def(34) = "caption,check"
	endwith
	with .Items
		.DefaultItem = .AddItem("Caption 1")
		.CellHasCheckBox(0,0) = .T.
		.DefaultItem = .AddItem("Caption 2")
		.CellHasCheckBox(0,0) = .T.
	endwith
endwith
450:
Can I change the order of the parts in the cell, as checkbox after the text, and so on

with thisform.Tree1
	var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql"
	var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0"
	var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN"
	var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	.Images(var_s)
	.Columns.Add("Column").Def(34) = "caption,check,icon,icons,picture"
	with .Items
		h = .AddItem("Text")
		.DefaultItem = h
		.CellImage(0,0) = 1
		.DefaultItem = h
		.CellHasCheckBox(0,0) = .T.
	endwith
endwith
449:
Can I have an image displayed after the text. Can I get that effect without using HTML content

with thisform.Tree1
	var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql"
	var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0"
	var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN"
	var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	.Images(var_s)
	.Columns.Add("Column").Def(34) = "caption,icon,check,icons,picture"
	with .Items
		h = .AddItem("Text")
		.DefaultItem = h
		.CellImage(0,0) = 1
	endwith
endwith
448:
Does your control support RightToLeft property for RTL languages or right to left

with thisform.Tree1
	.BeginUpdate
	.ScrollBars = 15
	.LinesAtRoot = -1
	with .Columns.Add("P1")
		.Def(0) = .T.
		.PartialCheck = .T.
	endwith
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
	.RightToLeft = .T.
	.EndUpdate
endwith
447:
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right

with thisform.Tree1
	.BeginUpdate
	.ScrollBars = 15
	with .Columns
		.Add("C1")
		.Add("C2")
		.Add("C3")
		.Add("C4")
		.Add("C5")
		.Add("C6")
		.Add("C7")
		.Add("C8")
	endwith
	.RightToLeft = .T.
	.EndUpdate
endwith
446:
How can I use the CASE statement (CASE usage)

with thisform.Tree1
	.BeginUpdate
	.Columns.Add("Value").Width = 24
	with .Columns.Add("CASE - statment")
		var_s = "%0 case (default:'not found';1:%0;2:2*%0;3:3*%0;4:4*%0;5:5*%0;7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen';14:'Fourth"
		var_s = var_s + "een')"
		.ComputedField = var_s
		.ToolTip = .ComputedField
	endwith
	with .Items
		.AddItem(0)
		.AddItem(1)
		.AddItem(2)
	endwith
	.EndUpdate
endwith
445:
How can I use the CASE statement (CASE usage)

with thisform.Tree1
	.BeginUpdate
	.Columns.Add("Value").Width = 24
	with .Columns.Add("CASE - statment")
		var_s = "%0 case (default:'not found';1:'One';2:'Two';3:'Three';4:'Four';5:'Five';7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen'"
		var_s = var_s + ";14:'Fourtheen')"
		.ComputedField = var_s
		.ToolTip = .ComputedField
	endwith
	with .Items
		.AddItem(0)
		.AddItem(1)
		.AddItem(2)
	endwith
	.EndUpdate
endwith
444:
I have seen the IN function but it returns -1 or 0. How can I display the value being found ( SWITCH usage )

with thisform.Tree1
	.BeginUpdate
	.Columns.Add("Value").Width = 24
	with .Columns.Add("SWITCH - statment")
		.ComputedField = "%0 switch ('not found', 1,2,3,4,5,7,8,9,11,13,14)"
		.ToolTip = .ComputedField
	endwith
	with .Items
		.AddItem(0)
		.AddItem(1)
		.AddItem(2)
	endwith
	.EndUpdate
endwith
443:
I have a large collection of constant values and using or operator is a time consuming (IN usage). Is there any way to increase the speed to check if a value maches the collection

with thisform.Tree1
	.BeginUpdate
	.Columns.Add("Value").Width = 24
	with .Columns.Add("IN - statment")
		.ComputedField = "%0 in (1,2,3,4,5,7,8,9,11,13,14) ? 'found' : ''"
		.ToolTip = .ComputedField
	endwith
	with .Items
		.AddItem(0)
		.AddItem(1)
		.AddItem(2)
	endwith
	.EndUpdate
endwith
442:
Is is possible to use HTML tags to display in the filter caption

with thisform.Tree1
	.BeginUpdate
	.FilterBarPromptVisible = .T.
	.FilterBarCaption = "This is a bit of text being displayed in the filter bar."
	.Columns.Add("")
	with .Items
		.AddItem("Item 1")
		.AddItem("Item 2")
		.AddItem("Item 3")
	endwith
	.EndUpdate
endwith
441:
How can I find the number of items after filtering
with thisform.Tree1
	.BeginUpdate
	.Columns.Add("")
	with .Items
		h = .AddItem("")
		.DefaultItem = h
		.CellCaption(0,0) = .VisibleItemCount
	endwith
	.EndUpdate
endwith
440:
How can I change the filter caption

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 12801 && FilterPromptEnum.exFilterPromptWords Or FilterPromptEnum.exFilterPromptContainsAll
	.FilterBarPromptPattern = "london robert"
	.FilterBarCaption = "<r>Found: ... "
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
439:
While using the filter prompt is it is possible to use wild characters

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 16
	.FilterBarPromptPattern = "lon* seat*"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
438:
How can I list all items that contains any of specified words, not necessary at the beggining

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 4610 && FilterPromptEnum.exFilterPromptStartWords Or FilterPromptEnum.exFilterPromptContainsAny
	.FilterBarPromptPattern = "london davolio"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
437:
How can I list all items that contains any of specified words, not strings

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 12802 && FilterPromptEnum.exFilterPromptWords Or FilterPromptEnum.exFilterPromptContainsAny
	.FilterBarPromptPattern = "london nancy"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
436:
How can I list all items that contains all specified words, not strings

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 12801 && FilterPromptEnum.exFilterPromptWords Or FilterPromptEnum.exFilterPromptContainsAll
	.FilterBarPromptPattern = "london robert"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
435:
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 258 && FilterPromptEnum.exFilterPromptCaseSensitive Or FilterPromptEnum.exFilterPromptContainsAny
	.FilterBarPromptPattern = "Anne"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
434:
Is it possible to list only items that ends with any of specified strings

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 4
	.FilterBarPromptColumns = "0"
	.FilterBarPromptPattern = "Fuller"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
433:
Is it possible to list only items that ends with any of specified strings

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 4
	.FilterBarPromptColumns = "0"
	.FilterBarPromptPattern = "Fuller"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
432:
Is it possible to list only items that starts with any of specified strings

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 3
	.FilterBarPromptColumns = "0"
	.FilterBarPromptPattern = "An M"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
431:
Is it possible to list only items that starts with specified string

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 3
	.FilterBarPromptColumns = "0"
	.FilterBarPromptPattern = "A"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
430:
How can I specify that the list should include any of the seqeunces in the pattern

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 2
	.FilterBarPromptPattern = "london seattle"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
429:
How can I specify that all sequences in the filter pattern must be included in the list

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptType = 1
	.FilterBarPromptPattern = "london manager"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
428:
How do I change at runtime the filter prompt

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptPattern = "london manager"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
427:
How do I specify to filter only a single column when using the filter prompt

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPromptColumns = "2,3"
	.FilterBarPromptPattern = "london"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
426:
How do I change the prompt or the caption being displayed in the filter bar

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	.FilterBarPrompt = "changed"
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	.EndUpdate
endwith
425:
How do I enable the filter prompt feature

with thisform.Tree1
	.BeginUpdate
	.ColumnAutoResize = .T.
	.ContinueColumnScroll = 0
	.MarkSearchColumn = .F.
	.SearchColumnIndex = 1
	.FilterBarPromptVisible = .T.
	with .Columns
		.Add("Name").Width = 96
		.Add("Title").Width = 96
		.Add("City")
	endwith
	with .Items
		h0 = .AddItem("Nancy Davolio")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Andrew Fuller")
		.DefaultItem = h0
		.CellCaption(0,1) = "Vice President, Sales"
		.DefaultItem = h0
		.CellCaption(0,2) = "Tacoma"
		.DefaultItem = h0
		.SelectItem(0) = .T.
		h0 = .AddItem("Janet Leverling")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Kirkland"
		h0 = .AddItem("Margaret Peacock")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "Redmond"
		h0 = .AddItem("Steven Buchanan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Manager"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Michael Suyama")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Robert King")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
		h0 = .AddItem("Laura Callahan")
		.DefaultItem = h0
		.CellCaption(0,1) = "Inside Sales Coordinator"
		.DefaultItem = h0
		.CellCaption(0,2) = "Seattle"
		h0 = .AddItem("Anne Dodsworth")
		.DefaultItem = h0
		.CellCaption(0,1) = "Sales Representative"
		.DefaultItem = h0
		.CellCaption(0,2) = "London"
	endwith
	.EndUpdate
endwith
424:
I have an EBN file how can I apply different colors to it, so no need to create a new one

with thisform.Tree1
	.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
	.SelBackColor = .BackColor
	.SelForeColor = .ForeColor
	.HasLines = 0
	.Columns.Add("Default")
	with .Items
		h = .AddItem("Root")
		hC = .InsertItem(h,Null,"Default")
		.DefaultItem = hC
		.ItemBackColor(0) = 0x1000000
		.DefaultItem = .InsertItem(h,Null,"")
		.ItemHeight(0) = 6
		hC = .InsertItem(h,Null,"Light Green")
		.DefaultItem = hC
		.ItemBackColor(0) = 0x100ff00
		.DefaultItem = .InsertItem(h,Null,"")
		.ItemHeight(0) = 6
		hC = .InsertItem(h,Null,"Dark Green")
		.DefaultItem = hC
		.ItemBackColor(0) = 0x1007f00
		.DefaultItem = .InsertItem(h,Null,"")
		.ItemHeight(0) = 6
		hC = .InsertItem(h,Null,"Magenta")
		.DefaultItem = hC
		.ItemBackColor(0) = 0x1ff7fff
		.DefaultItem = .InsertItem(h,Null,"")
		.ItemHeight(0) = 6
		hC = .InsertItem(h,Null,"Yellow")
		.DefaultItem = hC
		.ItemBackColor(0) = 0x17fffff
		.DefaultItem = .InsertItem(h,Null,"")
		.ItemHeight(0) = 6
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
423:
How can I change the foreground color for a particular column

with thisform.Tree1
	with .Columns
		.Add("Column 1")
		.Add("Column 2").Def(8) = 8439039
		.Add("Column 3")
	endwith
endwith
422:
How can I change the background color for a particular column

with thisform.Tree1
	with .Columns
		.Add("Column 1")
		.Add("Column 2").Def(7) = 8439039
		.Add("Column 3")
	endwith
endwith
421:
How can I display the column using currency format and enlarge the font for certain values

with thisform.Tree1
	with .Columns.Add("Currency")
		.Def(17) = 1
		.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)"
	endwith
	with .Items
		.AddItem("1.23")
		.AddItem("2.34")
		.AddItem("9.94")
		.AddItem("11.94")
		.AddItem("1000")
	endwith
endwith
420:
How can I highlight only parts of the cells

with thisform.Tree1
	with .Columns.Add("")
		.Def(17) = 1
		.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'"
	endwith
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
419:
How can I get the number of occurrences of a specified string in the cell

with thisform.Tree1
	.Columns.Add("")
	with .Columns.Add("occurrences")
		.ComputedField = "lower(%0) count 'o'"
		.FormatColumn = "'contains ' + value + ' of \'o\' chars'"
	endwith
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1 oooof the root")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"Child 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
418:
How can I display dates in my format

with thisform.Tree1
	with .Columns.Add("Date")
		.Def(17) = 1
		.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'"
	endwith
	with .Items
		.AddItem({^2001-1-21})
		.AddItem({^2002-2-22})
		.AddItem({^2003-3-13})
		.AddItem({^2004-4-24})
	endwith
endwith
417:
How can I display dates in short format

with thisform.Tree1
	.Columns.Add("Date").FormatColumn = "shortdate(value)"
	with .Items
		.AddItem({^2001-1-1})
		.AddItem({^2002-2-2})
		.AddItem({^2003-3-3})
		.AddItem({^2004-4-4})
	endwith
endwith
416:
How can I display dates in long format

with thisform.Tree1
	.Columns.Add("Date").FormatColumn = "longdate(value)"
	with .Items
		.AddItem({^2001-1-1})
		.AddItem({^2002-2-2})
		.AddItem({^2003-3-3})
		.AddItem({^2004-4-4})
	endwith
endwith
415:
How can I display only the right part of the cell

with thisform.Tree1
	.Columns.Add("")
	with .Columns.Add("Right")
		.ComputedField = "%0 right 2"
		.FormatColumn = "'"+chr(34)+"' + value + '"+chr(34)+"'"
	endwith
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"SChild 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
414:
How can I display only the left part of the cell

with thisform.Tree1
	.Columns.Add("")
	.Columns.Add("Left").ComputedField = "%0 left 2"
	with .Items
		h = .AddItem("Root")
		.InsertItem(h,Null,"Child 1")
		.InsertItem(h,Null,"Child 2")
		.InsertItem(h,Null,"SChild 3")
		.DefaultItem = h
		.ExpandItem(0) = .T.
	endwith
endwith
413:
How can I display true or false instead 0 and -1

with thisform.Tree1
	.Columns.Add("Boolean").FormatColumn = "value != 0 ? 'true' : 'false'"
	with .Items
		.AddItem(.T.)
		.AddItem(.F.)
		.AddItem(.T.)
		.AddItem(0)
		.AddItem(1)
	endwith
endwith
412:
How can I display icons or images instead numbers

with thisform.Tree1
	var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql"
	var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0"
	var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN"
	var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="
	.Images(var_s)
	with .Columns.Add("Icons")
		.Def(17) = 1
		.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value"
	endwith
	with .Items
		.AddItem(1)
		.AddItem(2)
		.AddItem(3)
	endwith
endwith
411:
How can I display the column using currency

with thisform.Tree1
	.Columns.Add("Currency").FormatColumn = "currency(dbl(value))"
	with .Items
		.AddItem("1.23")
		.AddItem("2.34")
		.AddItem("0")
		.AddItem(5)
		.AddItem("10000.99")
	endwith
endwith
410:
How can I display the currency only for not empty cells

with thisform.Tree1
	.Columns.Add("Number")
	.Columns.Add("Currency").ComputedField = "len(%0) ? currency(dbl(%0)) : ''"
	with .Items
		.AddItem("1.23")
		.AddItem("2.34")
		.AddItem("0")
		.DefaultItem = .AddItem()
		.ItemBackColor(0) = RGB(255,128,128)
		.AddItem("10000.99")
	endwith
endwith
409:
Is there a function to display the number of days between two date including the number of hours

with thisform.Tree1
	.Columns.Add("Start").Width = 32
	.Columns.Add("End")
	var_s = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : '"
	var_s = var_s + "') + =:3 + ' hour(s)' : '' )"
	.Columns.Add("Duration").ComputedField = var_s
	with .Items
		h = .AddItem({^2001-1-11})
		.DefaultItem = h
		.CellCaption(0,1) = {^2001-1-14}
		h = .AddItem({^2002-2-22 12:00:00})
		.DefaultItem = h
		.CellCaption(0,1) = {^2002-3-14 13:00:00}
		h = .AddItem({^2003-3-13})
		.DefaultItem = h
		.CellCaption(0,1) = {^2003-4-11 11:00:00}
	endwith
endwith
408:
Is there a function to display the number of days between two date including the number of hours

with thisform.Tree1
	.Columns.Add("Start")
	.Columns.Add("End")
	.Columns.Add("Duration").ComputedField = ""+chr(34)+"D "+chr(34)+" + int(date(%1)-date(%0)) + "+chr(34)+" H "+chr(34)+" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))"
	with .Items
		h = .AddItem({^2001-1-11})
		.DefaultItem = h
		.CellCaption(0,1) = {^2001-1-14 23:00:00}
		h = .AddItem({^2002-2-22 12:00:00})
		.DefaultItem = h
		.CellCaption(0,1) = {^2002-3-14 13:00:00}
		h = .AddItem({^2003-3-13})
		.DefaultItem = h
		.CellCaption(0,1) = {^2003-4-11 11:00:00}
	endwith
endwith
407:
How can I display the number of days between two dates

with thisform.Tree1
	.Columns.Add("Start")
	.Columns.Add("End")
	.Columns.Add("Duration").ComputedField = "(date(%1)-date(%0)) + ' days'"
	with .Items
		h = .AddItem({^2001-1-11})
		.DefaultItem = h
		.CellCaption(0,1) = {^2001-1-14}
		h = .AddItem({^2002-2-22})
		.DefaultItem = h
		.CellCaption(0,1) = {^2002-3-14}
		h = .AddItem({^2003-3-13})
		.DefaultItem = h
		.CellCaption(0,1) = {^2003-4-11}
	endwith
endwith
406:
How can I get second part of the date

with thisform.Tree1
	.Columns.Add("Date")
	.Columns.Add("Second").ComputedField = "sec(date(%0))"
	with .Items
		.AddItem({^2001-1-11 10:10:00})
		.AddItem({^2002-2-22 11:01:22})
		.AddItem({^2003-3-13 12:23:01})
		.AddItem({^2004-4-14 13:11:59})
	endwith
endwith
405:
How can I get minute part of the date

with thisform.Tree1
	.Columns.Add("Date")
	.Columns.Add("Minute").ComputedField = "min(date(%0))"
	with .Items
		.AddItem({^2001-1-11 10:10:00})
		.AddItem({^2002-2-22 11:01:00})
		.AddItem({^2003-3-13 12:23:00})
		.AddItem({^2004-4-14 13:11:00})
	endwith
endwith
404:
How can I check the hour part only so I know it was afternoon

with thisform.Tree1
	.ConditionalFormats.Add("hour(%0)>=12").Bold = .T.
	.Columns.Add("Date")
	.Columns.Add("Hour").ComputedField = "hour(%0)"
	with .Items
		.AddItem({^2001-1-11 10:00:00})
		.AddItem({^2002-2-22 11:00:00})
		.AddItem({^2003-3-13 12:00:00})
		.AddItem({^2004-4-14 13:00:00})
	endwith
endwith
403:
What about a function to get the day in the week, or days since Sunday

with thisform.Tree1
	.Columns.Add("Date")
	.Columns.Add("WeekDay").ComputedField = "weekday(%0)"
	with .Items
		.AddItem({^2001-1-11 10:00:00})
		.AddItem({^2002-2-22 11:00:00})
		.AddItem({^2003-3-13 12:00:00})
		.AddItem({^2004-4-14 13:00:00})
	endwith
endwith
402:
Is there any function to get the day of the year or number of days since January 1st

with thisform.Tree1
	.Columns.Add("Date")
	.Columns.Add("Day since January 1st").ComputedField = "yearday(%0)"
	with .Items
		.AddItem({^2001-1-11 10:00:00})
		.AddItem({^2002-2-22 11:00:00})
		.AddItem({^2003-3-13 12:00:00})
		.AddItem({^2004-4-14 13:00:00})
	endwith
endwith
401:
How can I display only the day of the date

with thisform.Tree1
	.Columns.Add("Date")
	.Columns.Add("Day").ComputedField = "day(%0)"
	with .Items
		.AddItem({^2001-1-11 10:00:00})
		.AddItem({^2002-2-22 11:00:00})
		.AddItem({^2003-3-13 12:00:00})
		.AddItem({^2004-4-14 13:00:00})
	endwith
endwith