SQL Update

[Ruslan Zasukhin]

On 5/26/11 7:48 AM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:

Hi Warren ,

> I am trying to update a field (term1) with commas.  I understand if I
> add a "\" before the comma, it should work?  Is there a better way to
> do this?  Or is this the best method?
> 
>          put VDataBase_SqlExecute(mDatabase,"Update Table1 set Term1 =
> " & term1 & " where keyword1 = " & keyword1 & "'")

You mean 

    Term1 = Some Value, With Comas

?

First of all, this is tring.
It should be in single quotes

    Term1 = 'Some Value, With Comas'

Then never mind if comas present inside

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]