V4WS problem with sql update of VarChar field

[Bob Raycher]

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