V4WS problem with sql update of VarChar field

[Ruslan Zasukhin]

on 6/13/03 1:51, Bob Raycher at raycher at ccsmac.com wrote:

> Further testing. If I set the Methods field to both indexed and index by
> words, I do not get a crash.  Is this required?

In fact no.

If you set only Indexed by Words, then Valentina when it needs will start
build index, and it will know that you want index by words.
So this must work of course.
 
> Thanks,
> 
> Bob
> 
>> I tried using the single quote as you suggested, but this did not help. After
>> running many variations of field types and sizes (string, text 100-5000) I
>> found the problem.
>> 
>> The problem was not with the options field itself but with an associated
>> methods field.
>> 
>> Throughout the testing I had a Methods field optionsUpper with a calculation
>> of UPPER(options). If I make this methods field Indexed by Words, then I get
>> the crash. If I make it simply Indexed then no crash.
>> 
>> Any thoughts?

-- 
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
-------------------------------------------------------------