Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Xbase Fox > VFP6 fuzzy sear...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 802 of 852
Post > Topic >>

VFP6 fuzzy search

by Jim <TheOneTrueJimN@[EMAIL PROTECTED] > Aug 23, 2007 at 09:19 PM

I'm trying to do a fuzzy search on two fields from two textboxes.
It looks something like this:
"SELECT [fields] FROM [table] WHERE [field1] LIKE '%'+textbox1.value+'%'
AND 
[field2] LIKE '%'+textbox2.value+'%' ORDER BY [fields] INTO CURSOR"

I get an error when I try to save if I don't remove one of the '%' in the 
middle. Is there a fix for my syntax or do I need to do a workaround?

Thanks,
Jim
 




 1 Posts in Topic:
VFP6 fuzzy search
Jim <TheOneTrueJimN@[E  2007-08-23 21:19:03 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 17:20:09 CDT 2008.