V4WS problem with sql update of VarChar field

[Bob Raycher]

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

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?
> 
> Thanks,
> 
> Bob
> 
> 
> on 6/12/03 3:12 PM, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:
> 
>> on 6/12/03 17:58, Bob Raycher at raycher at ccsmac.com wrote:
>> 
>>> I am having a problem with using valSqlExecute on a VarChar field.
>>> 
>>> I tried using ViSQL Carbon with the following:
>>> 
>>> update Vehicleinfo set options = "Has many new features" where RecID = 2
>>> 
>>> options is VarChar, 5000, IndexedbyWords
>>> 
>>> I have other fields of string, Ulong, Umedium and Double and they all seem
>>> to update correctly.
>>> 
>>> Any suggestions?
>> 
>> Hi Bob,
>> 
>> In fact you need use single quotes:
>> 
>>   update Vehicleinfo set options = 'Has many new features' where RecID = 2
>> 
>> Try this