[AccessD] SQL statement problem

Stuart McLachlan stuart at lexacorp.com.pg
Thu May 8 19:46:13 CDT 2003


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



More information about the AccessD mailing list