SQL Update

[william humphrey]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110526/5e37f673/attachment-0001.html>