PROCEDURE Valid
This.Refresh()
ENDPROC
PROCEDURE Init
DoDefault()
select StaffName from travel!supers order by staffname into array This.aList
dimension This.aList(alen(This.aList, 1))
local lnResult
lnResult = 1
if !empty(This.ControlSource)
lnResult = ascan(This.aList, eval(This.ControlSource))
endif
if lnResult = 0
local lnLen
lnLen = alen(This.aList, 1) + 1
dimension This.aList[lnLen]
This.aList[lnLen] = eval(This.ControlSource)
This.NumberOfElements = lnLen
asort(This.aList)
endif
This.Requery()
return
ENDPROC
PROCEDURE Refresh
local lnResult, lcOldValue
lnResult = 1
lcOldValue = This.DisplayValue
if !empty(lcOldValue)
lnResult = ascan(This.aList, lcOldValue)
endif
if lnResult = 0
local lnLen
lnLen = alen(This.aList, 1) + 1
dimension This.aList[lnLen]
This.aList[lnLen] = lcOldValue
This.NumberOfElements = lnLen
asort(This.aList)
endif
This.DisplayValue = lcOldValue
This.Value = lcOldvalue
ENDPROCMark McCasland
Midlothian, TX USA