[attributions likely mucked]
At 14:30 2014-09-03, AndyHC <[email protected]> wrote:
On 03/09/2014 15:54, Michael Glassman wrote:
From: Sytze de Boer
[snip]
I have a large stock file (say 10,000 records)
I only have a vague idea what I'm searching for
So, I may have a variable like
srch4="upper(name+code+stkmemo+unitmeas2+altsupply+descopt2+descopt3+descopt4+descopt5+bar2code+bar3code+alt2code)"
"name" is a reserved word. You should use a different name.
(BTW, according to the help, "naptime" is a reserved word. A
search shows it occurs only in the reserved word list. What gives?)
You could get a false positive when the search value spans more
than one column. Given
column1: "con"
column2: "trived"
searching on column1+column2 for "cont" will give a hit.
Is there a better/quicker way to CONSTRUCT the following
Select Code, desc, price, cost, qoh from winstoks Into Table temp order By
Code where At(lcSearch,&srch4)>0
#bad# database design - sorry!
Oh? What would you do given a requirement to be able to search
several of a table's columns? Or did you mean something else?
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** 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.
