John Check out KEY() and SYS(14)
John J. Mihaljevic wrote: > Hi all, > > I've got a Search box on my form that will let the user search the active > table based upon whatever the current sort order is (the currently active > index tag). For example, my Customers table. > > I want them to be able to enter either a Customer Number or a Customer Name, > and have it search the table based upon whichever index tag is currently > selected. If they enter a digit (for example, 9), I need to know if it > should be treated as a digit (for example, Customer Number 9) or a character > (for example, "9 Industries") depending on what the currently active index > order is. > > Using vartype() for the fields Name or Number wouldn't be good enough > because the current index tag may be comprised of more than one field that > aren't all numeric or all character. > > Thanks much, > > John > "The difference between a successful person and others is not a lack of > strength, not a lack of knowledge, but lack of will." - Vince Lombardi > > * All mail scanned by Norton AntiVirus. No AV software on your computer? > Remove me from your address book, please. > > * Please respect my privacy. Do not forward my address to anyone else or > include me in emails sent to multiple recipients. Use BCC. > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
