[AccessD] SQL statement problem

Thanks, Stuart, using the Replace worked, I completely misses the ' in
"doesn't" in the error description.

I appreciate everyone's assistance in this, it was just driving me crazy.  I
tried each and every solution, and have learned a lot in the process.  And
now I have set up a system that I can play with, that records the errors I
want, when they happen, in what procedure, who was using it, etc.

Again, many thanks to everyone, this is THE best list!

Nancy L

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Thursday, May 08, 2003 8:46 PM
To: accessd at databaseadvisors.com; Nancy Lytle
Subject: RE: [AccessD] SQL statement problem


On 8 May 2003 at 17:19, Jim Lawrence (AccessD) wrote:

>
> I have used this same technique many times in the past, but this time it
> just won't work.
>
> It has to be the single quotes inside the Err_Description.
>

If you are trying to insert a single quote in a field in an SQL statement
you need to "Escape" it by making it two
consecutive single quotes.

Try Replace("ErrDescription",Chr$(39),CHr$(39) & Chr$(39)) instead of just
ErrDescription


--
Stuart McLachlan
Lexacorp Ltd
Application Development,  IT Consultancy
http://www.lexacorp.com.pg

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com