All you have to do is double up any apostrophes in your strings. So, your
query would become:

> >>
>Select c.name, p.LastName, p.Name from Companies c, Persons p
>where p.Name containing 'James O''Rourke'
>and p.CompanyNr = c.CompanyNr
><<

(that's two apostrophes, not a double quote)

I just created a function that goes through a string and doubles up any
apostrophes in it. I pass my string through that function before using it
in a query.

-Joe


At 09:00 PM 11/12/2004, you wrote:

>Yes, that works, but the query is formed externally to Delphi, and is more
>involved, so that I cannot see how to parse the portion to send to
>QuotedStr(). Suppose that my query is:
>
> >>
>Select c.name, p.LastName, p.Name from Companies c, Persons p
>where p.Name containing 'James O'Rourke'
>and p.CompanyNr = c.CompanyNr
><<
>
>Here is where I ran into my problem: It becomes ambiguous to know how to
>pass the correct parameter (James O'Rourke) to QuotedStr. How can Delphi
>know whether the second apostrophe terminates the string (James O), or that
>it should go on to find a third apostrophe?
>
>Maybe the query just cannot be formed externally in this case...then I might
>be able to use the Delphi function. There are only a few instances of this.
>Might work...
>
>jwc
>
>-----Original Message-----
>From: Helen Borrie [mailto:helebor@...]
>Sent: Friday, November 12, 2004 11:08 PM
>To: IBObjects@yahoogroups.com
>Subject: Re: [IBO] Apostrphe within single quotes
>
>
>At 09:48 PM 12/11/2004 -0500, you wrote:
>
> >Suppose a user's input contains a search string like O'Rourke. The
>resulting
> >query would then contain the qualifier, ".where Last_Name containing (or =)
> >'O'Rourke'. To avoid a SQL error, this needs to be changed to 'O''Rourke'.
> >The obvious solution is simply to advise the user to add the second
> >apostrophe manually. To try and avoid that, I have played with this a bit,
> >but cannot find my way out of the semantic box created by the ambiguity
> >between the apostrophe in the name and the ending single quote. Wondered if
> >any of you know of a solution.
>
>Easy!! Let Delphi do the walking ---
>
>ParamByName('CharacterField').AsString :=
>QuotedStr(ParamByName('CharacterField').AsString);
>
>HB
>
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>