Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement