Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dealing with set exact on
Message
From
14/04/2009 15:41:19
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01394811
Message ID:
01394818
Views:
62
This message has been marked as a message which has helped to the initial question of the thread.
>It's a software for parking lot that I developed one year ago
>
>Car tags standard here are 3 letters and 4 numbers as: QAX9191
>
>To prevent customers to type QAX919 (motorcicle or foregner tags) and find the car tag QAX9191 accidently
>I turned "set exact on"
>
>However a customer of mine wants to search only by the car tag number
>
>He wants to type 9191 and finds QAX9191
>
>The problem is that I use the whole search in unique textbox
>
>Is it possible to solve this problem withtout adding another textbox or a "set exact off " button ?

One thing you could do would be to run both exact and inexact/partial queries, and present both sets of results.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform