Got ya... But wonder if you wanted to update the field with "O'Malley"? How could you do that? I have long memo fields in SQL that tons of approstrophies and single quotes. I'm bring them into VFP with SQL Select, and want the user to update in an edit field, press
, and then I do a SQL UPDATE fuction.
thanks....
>No. It is 2 consecutive single quotes.
>
>>But isn't that a double quote in O'Malley?
>>
>>
>>
>>>>I am trying to UPDATE a SQL table that has single quotes and appostrophies inside the field1. I can't use double quotes around my character field. Does anyone know of a solution for this.
>>>>
>>>>lcSQLUpdate = "update table1 set field1 = '"+foxvar1+"' where sqlvar=x"
>>>>
>>>>Thanks,
>>>
>>>This works for me:
>>>
>>>SQLEXEC(lnHandle, [update appusers set lastname = 'O''Malley' where keyid = 2])
Frederick Kusin
NetBase Development Group
3746 Folsom Street
San Francisco, CA. 94110
www.netbasegroup.com