V4WS problem with sql update of VarChar field

[Ruslan Zasukhin]

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

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