[attributions likely mucked]

At 14:30 2014-09-03, AndyHC <jarndice@gmail.com> 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: ProFox@leafe.com

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.