SQL Update

[Warren Kuhl]

Sorry, I actually meant single quotes.  My mistake.

Example: Term1 = 'Bob's house is green'

Warren

On Thu, May 26, 2011 at 2:03 AM, Ruslan Zasukhin
<ruslan_zasukhin at valentina-db.com> wrote:
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>