[SQL] Related table question [Workaroung]

[Ruslan Zasukhin]

on 1/21/04 5:05 PM, Eric Forget at forgete at cafederic.com wrote:

> Hi Ruslan,
> 
> I've found a workaround. In the main table, I create a field of type Text
> "KeywordNames". It is formatted like this "\001keyword1\001\001eyword2\001".
> I've used the character '\001' since it is not printable.
> 
> The drawbacks are that search maybe a bit slower and it increases the size
> of the database. However, it would make my life a lot easier...
> 
> Even if I do not use your solutions, I've learned a few SQL tricks with this
> process that I may use in the future for other stuffs.
> 
> Thank you for your help...

Hi Eric,

Okay,

Then may be you need just use TEXT/VarChar field
An storey keywords separated by space
And apply Index by words?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------