• Welcome, Guest. Please login.
 
October 19, 2021, 12:37:25 AM

News:

Welcome to the SQLitening support forums!


Single quote problem

Started by Fredrick Ughimi, March 31, 2011, 12:21:23 PM

Previous topic - Next topic

Fredrick Ughimi

Hello,

A field value was entered as SA
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fred Meier

Use the PB Replace command to replace all single quotes with two single quotes.

Jean-Pierre LEROY

Frederik,

I use the function below each time:
Function SQTo2SQ(ByVal pString As String) As String
    Replace "'" With "''" In pString
    Function = pString
End Function

Jean-Pierre

Fredrick Ughimi

Hello Fred,

Worked like a champ.


   
    sOthernames = VD_GetText(hFindOthernames&, %ID_FRMFINDOTHERNAMES_TXTOTHERNAMES)
   
    Replace "'" With "''" In sOthernames
   


Thank you.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

Hello Jean,

Thank you for the heads up.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet