General information
Title:
Repost - Search Expression needs UDF
I'm reposting this because I originally posted it when everyone was at DevCon and didn't get the needed help....
I am using Stonefield Query for my find screen. When I press the find button, Stonefield Filter screen is invoked. (Good!). I have an unusual circumstance on my Customer and Vendor numbers. My field can contain either numbers or alpha characters - but not both.
The index I usually use on this field is:
IIF(VAL(custno)=0,custno,PADL(STR(VAL(custno),10),10))
When I enter a Filter like: Customer (field name from lookup) EQUALS '10', I get no records. I must enter it like ' 10' in order to get a match. This is too hard to remember for the clients, so I want to put some custom code in the field screen to change the search expression with respect to custno or vendno (field names) to the above mentioned expression. Where do I put this code?
TIA
Sandi Cassidy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only