A small challenge...
I've worked out how to filter a table on a specific text entry
table1.Filter("ColName = '*xyz*'")
I now have two questions wrapped up in one...
1/ is it possible to (easily) find all entries in a column (or columns) that contain the characters X and Y (case insensitive but in that order) and filter on that so "abXcdYe", "abcXYde" and "XabcdeY" would all be shown
2/ is it possible to build a string on a smartphone by simply trapping keys from the form (using the door library) and avoid the need for a visible text box? I'm guessing character 8 would need trapping as delete and while it's straightforward on a Dash or BlackJack (full QWERTY keyboard) on a T9 (Touch Dual) to a T20 device (Shadow) you'd have to allow for any of the possible key values (eg rather than filtering for X in a specific position filter on X,Z or @ for instance)
To give you the scenario... I have a contact list and I want to rapidally allow a user to narrow down to a particular name by tapping in a few characters 9much like in some of the dialer apps) ... at it's simplest typing "off" (or hitting the OP key, the 4DF and 4DF key on the Shadow) to find "offbeatmammal" (or "office" or "bugoff externimators") and I'd be happy with that... if it could also find words that have an O/P followed by F/D/4 and F/D/4 (in any combination but in that order) it would be a huge bonus
any thoughts most welcome
I've worked out how to filter a table on a specific text entry
table1.Filter("ColName = '*xyz*'")
I now have two questions wrapped up in one...
1/ is it possible to (easily) find all entries in a column (or columns) that contain the characters X and Y (case insensitive but in that order) and filter on that so "abXcdYe", "abcXYde" and "XabcdeY" would all be shown
2/ is it possible to build a string on a smartphone by simply trapping keys from the form (using the door library) and avoid the need for a visible text box? I'm guessing character 8 would need trapping as delete and while it's straightforward on a Dash or BlackJack (full QWERTY keyboard) on a T9 (Touch Dual) to a T20 device (Shadow) you'd have to allow for any of the possible key values (eg rather than filtering for X in a specific position filter on X,Z or @ for instance)
To give you the scenario... I have a contact list and I want to rapidally allow a user to narrow down to a particular name by tapping in a few characters 9much like in some of the dialer apps) ... at it's simplest typing "off" (or hitting the OP key, the 4DF and 4DF key on the Shadow) to find "offbeatmammal" (or "office" or "bugoff externimators") and I'd be happy with that... if it could also find words that have an O/P followed by F/D/4 and F/D/4 (in any combination but in that order) it would be a huge bonus
any thoughts most welcome