SQL Update

[Warren Kuhl]

Bill,

Thanks for the suggestion.  I will check that out!

Warren

On Thu, May 26, 2011 at 9:05 AM, william humphrey
<bill at bluewatermaritime.com> wrote:
> I use "Valentina_EscapeString" command on livecode. It works great for that.
>
> On Thu, May 26, 2011 at 9:16 AM, Warren Kuhl <warrenkuhl at gmail.com> wrote:
>>
>> I don't know of the exact verbage, but isn't there a way to pass in
>> the values which will be able to take care of the single quotes in a
>> field:
>>
>> ie.
>> put VDataBase_SqlExecute(mDatabase,"Update Table1 set Term1 = :1 where
>> keyword1 = :2", tTerm1, tKeyword1)
>>
>> Does something like the above SQL work in Valentina?  If so...does it
>> take care of the single quotes in a SQL?
>>
>> Warren
>>
>>
>> On Thu, May 26, 2011 at 6:35 AM, Warren Kuhl <warrenkuhl at gmail.com> wrote:
>> > 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
>> >>
>> >
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
>
>
> --
> http://www.bluewatermaritime.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>