Posted by dragon on Friday, 7 October 2011
Can exist in Firebird records in which the apex appears: for example in CITTA'. In these cases Firebird does not accept the field. In order to avoid the problem you must double the apex. The function Replace for ex. can for this purpose be used in this way: “update Table set Field='" & Replace (Textbox1.text, "'", "''") & "'"