"inset single quote data using query"

[Coolbdy]

Hi all,

i am working with FileMaker pro 11,

and i want to insert data in the column using insert query(programmatically)

the data is in this form: brother's name

there is single quote between the characters.

when i execute query this gives syntax error.

how i insert single quoted data in the filemaker database using insert query command.

i m using FM ODBC 11.00.58.00 driver for this.

if any have information about this pls reply me.

Have a great day to all.