Revision
- From: George Wei <nobody@xxxxxxxxx>
- Date: 23 Aug 2006 01:08:23 -0700
George Wei <nobody@xxxxxxxxx> wrote in news:Xns9828A2927F04Cnobodyyahoocom@
207.105.83.66:
Str := 'Sawal Afa''at'
This line should be changed to the following:
Str := 'Sawal Afa''''at'
This puts 2 conjoint single quotation marks into the SQL statement, so the
SQL engine treats the first one as an escape Character.
George
.
- References:
- SQL Syntax for a single quote in a string.
- From: lsg
- Re: SQL Syntax for a single quote in a string.
- From: George Wei
- SQL Syntax for a single quote in a string.
- Prev by Date: Re: SQL Syntax for a single quote in a string.
- Next by Date: Re: SQL Syntax for a single quote in a string.
- Previous by thread: Re: SQL Syntax for a single quote in a string.
- Next by thread: Re: SQL Syntax for a single quote in a string.
- Index(es):
