SQL Update

[Warren Kuhl]

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
>>
>