Imagine you have a combo box.<\/p>\n
This combo box holds (and displays) the ‘NAME values’ which are records in database F but returns the ‘IDNO values’. (I’ll explain the logic behind this on a different post… later.)<\/p>\n
Database F contains only those two fields: the ‘NAME values’ which are mostly items\/descriptions and its corresponding ‘IDNO values’ (or CODE or CODENUMBER whatever you prefer, lovely-lady-of-mount-lithsoma).<\/p>\n
Now you ‘morph’ your combo box so that the text part would accept manual character entries and automatically filters the DropDown Items after its InteractiveChange event is triggered.<\/p>\n
Now here’s the question…<\/p>\n
If the user types, let’s say… the characters ‘CHART’, would you filter all the records having the string ‘CHART’ in it or just the records starting with the ‘CHART’ string?<\/p>\n
In other words would you:<\/p>\n
set filter to cBUFFER $ (upper(alltrim(DBASE.NAMEVALUE)))<\/font><\/p><\/blockquote>\n
… or would you:<\/p>\n
set filter to cBUFFER $ substr(DBASE.NAMEVALUE, 1, nLEN)<\/font><\/p><\/blockquote>\n
… given that:<\/p>\n
cBUFFER = upper(alltrim(this.Text))
nLEN = len(alltrim(cBUFFER))<\/font><\/p><\/blockquote>\n\nJust some little issues I’m pondering on at 2:30<\/font> in the morning.<\/p>\n
(And I am so tempted already to activate the comments feature of this blog.)<\/p>\n","protected":false},"excerpt":{"rendered":"
Imagine you have a combo box. This combo box holds (and displays) the ‘NAME values’ which are records in database F but returns the ‘IDNO values’. (I’ll explain the logic behind this on a different post… later.) Database F contains only those two fields: the ‘NAME values’ which are mostly items\/descriptions and its corresponding ‘IDNO […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,10],"tags":[],"class_list":["post-347","post","type-post","status-publish","format-standard","hentry","category-visual-foxpro","category-workblog"],"_links":{"self":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/posts\/347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/comments?post=347"}],"version-history":[{"count":0,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/posts\/347\/revisions"}],"wp:attachment":[{"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/media?parent=347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/categories?post=347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/foxpro.ntsl119.com\/scr\/wp-json\/wp\/v2\/tags?post=347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}