V4WS problem with sql update of VarChar field

Frank Schima frank-list at mindstarprods.com
Thu Jun 12 11:14:56 CDT 2003


Hi Bob,


On Thursday, June 12, 2003, at 10:58  AM, Bob Raycher 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?

I have a bunch of questions:
-What version of V4WS was used?
-What Valentina version in ViSQL?
-What did ViSQL say when you executed the SQL?
-Do you mean other field types UPDATEd properly in the same record 
using the same WHERE clause?


Best regards,
Frank

---
Frank Schima                <mailto:frank-list at-sign 
mindstarprods.com>
Independent Consultant
Gaithersburg, MD USA        <http://www.ci.gaithersburg.md.us/>



More information about the Valentina mailing list