Hi
Sorry for late reply.

You have 2 two ways for this.

1. Use standard escape sequences by doubling the special character ( in this case simple quote )

SQLEXEC(nConnHnd, [update rdb$relation_fields set rdb$description = 'Some text with ''quotes'''  where rdb$field_name = 'FIELD_NAME' and rdb$relation_name = 'TABLE_NAME'])

2. Use parameters

cDesc =  [Some text with 'quotes']
SQLEXEC(nConnHnd, [update rdb$relation_fields set rdb$description = ?cDesc  where rdb$field_name = 'FIELD_NAME' and rdb$relation_name = 'TABLE_NAME'])

In both cases, description is updated with single quotes.


>Also I have one more question to you regarding the desciptions. As strings can only be sent to the ODBC/FB in single quotes, eg. 'Dorin', how can I send a string like this 'Dorin's notebook'. The apostrophy s is creating a problem. I have tried both "Dorin's notebook" and [Dorin's notebook], just in case if it is valid in FB, but no luck. So right now I have used CHRTRAN() to convert ' to " and it does look funny 'Dorin"s notebook'.
>
>I have also tried to put a /, //, \, or a \\ before the ' like this /', //', \' and \\' but no luck.
>
>Please advise.