How insert apostrophe in string?

[lublinkermi]

Hi, I need string like this:

osql -S server -d database -E  -Q "BACKUP DATABASE database TO DISK ='c:\database' FORMAT";

If I wrote like Delphi:

osql -S server -d database -E  -Q "BACKUP DATABASE database TO DISK =''c:\database'' FORMAT";

'' - is a 2 aphostrophe
I see:
Fatal: Syntax error, ";" expected but "identifier C" found

How I can insert apostrophe in string in Lazarus?

[cjhs22a]

use the QuotedStr function

'BACKUP DATABASE database TO DISK =' + QuotedStr('c:\database') + ' FORMAT'

[marcov]

How I can insert apostrophe in string in Lazarus?

It works for me perfectly.  Could you provide an actually compilable example?

[fredycc]

Try using format function; I using it for any query:

For Example:

Format('INSERT INTO %s.dbo.%s ( %s ) VALUES ( ',[ZConnection2.Database,ComboBox2.Text,txFields])

More info:
http://www.delphibasics.co.uk/RTL.asp?Name=Format

Regards.

[typo]

If you write '''' (2 apostrophes inside apostrophes), you will have ' (1 apostrophe). So you could write '''Hello''' to have 'Hello'.

[lublinkermi]

I rebuild Lazarus and all works, thanks 

[Eugene Loza]

I add apostrophe as a char:
'...' +#39+ '...'