Hello Jack,

> I have set up my tables and fields with upper case to allow me to
> ignore case in my queries.

As Helen explained, you don't have to use upper case. As long as you
don't double-quote the names when you define them, they are case-
insensitive.

> Here is what I think I did

Umm.... *think* you did? What happened to your source code? ;-)

> With MyDSQL do begin
> SQL.Clear;
> SQL.Add('UPDATE MyTable SET MyField = ''ABC Company, Inc.''
> WHERE ID = 1');

This is correct. Surrounding ABC Company, Inc. with two single quotes
on either side will result in one single quote on either side in the
SQL statement - exactly what you need.

> Execute;

I always do a Prepare first, but maybe that's not necessary.

> End;

> When I opened an SQLMonitor to see what the server had received, it
> was something like this:
> UPDATE MyTable SET MyField = "'ABC Company, Inc.'".
>
> The component or the server added the double quotes but in this

Not the server. Did you step through your code in the debugger and
inspect or watch MyDSQL.SQL.Text after you'd set it?

If it doesn't work out, please post _exactly_ what's in your source
code and _exactly_ what you see in the Monitor.


Good night!
Paul Vinkenoog