Hello!

User enter text in my program and I use a query like this to insert it
into my firebird database

INSERT INTO notesdossiers (idDossier, idGroupe, idEmploye, ladate, notes)
VALUES(1, '0', 8, '06-06-2005', '" + theNote + "')

it works well when theNote don't have any single quote in it, but if the
user wrote single quote in is text, it doesn't work anymore.
For example:
theNote: I don't know why he called me back

If it helps, the field is a BLOB field.

thanks for any help!

Mona