V4WS problem with sql update of VarChar field

Bob Raycher raycher at ccsmac.com
Thu Jun 12 13:18:24 CDT 2003


1.9.7 V4WS
1.1a23 Carbon ViSQL
ViSQL simply crashes no error
The other fields updated properly when the VarChar field was removed from
the statement.

Thanks,

Bob

on 6/12/03 11:14 AM, Frank Schima at frank-list at mindstarprods.com wrote:

> 
> 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/>
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina



More information about the Valentina mailing list