SQL Update

Warren Kuhl warrenkuhl at gmail.com
Wed May 25 23:48:39 CDT 2011


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 & "'")

Thanks,
Warren


More information about the Valentina mailing list