Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching for words *within* a field
Message
From
31/08/2001 13:58:10
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00551437
Message ID:
00551549
Views:
25
Vlad,

Why not use a single table that contains:

Word
Link

Where "Link" contains a unique identifier for the record that contains this specific word. You could then use a SELECT such as this:

sele * from musictbl, dict where musictbl.unique_id == dict.linkid and (dict.word = "HOLY" or dict.word = "NIGHT")

Is there some advantage to your approach that I'm not seeing?

Pete
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform