In my SCv6 project, I use the values in some DB fields to update rows in other tables. In some of those fields, punctuation exists such as the apostrophe character. So, this messes up SCv6 when it makes an UPDATE statement for me, the apostrophe is “in the way”. Normally, in Firebird, you would just double the apostrophe and the SQL would execute normally. Firebird would understand that the double apostrophe is to be part of the updated field data, and is not the end of the value string. In SCv6, how do I tell it that when a value comes from field_1 that IF it contains a ’ that I want it replaced with two apostrophes?
Re: Fields containing ’ to SQL
Simply replace the apostrophe character
"'"
with double-apostrophe character
"''"
using str_replace() function that belongs to PHP.
Sincerely,
Masino Sinaga