Yes, it does (like wot I sed <g>) SQLDISCONNECT(0) nHndl = SQLCONNECT('tstAccess') ?SQLEXEC(nHndl,[select * from tstTable]) ?SQLEXEC(nHndl,"insert into tstTable (name, stuff) VALUES ('O''Murphy','spt quot in sngl quots')") ?SQLEXEC(nHndl,[select * from tstTable]) SQLDISCONNECT(0)
Andrew Davies MBCS CITP - AndyD 8-)#
Ted Roche <tedroche@tedroch To: profoxtech .AT. leafe DO.T com e.com> cc: Sent by: Subject: Re: SPT & Access Heck profoxtech-bounce s@leafe.com 30/04/2005 13:06 Please respond to profox
I think two apostrophes should work. Check out:
http://support.microsoft.com/kb/q178070/
On Apr 29, 2005, at 5:12 PM, Ken Kixmoeller wrote:
> I am in SPT -> Access Hades again.
Well, if you stopped playing with fire, you'd stop getting burnt...
Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com
[excessive quoting removed by server]
©2005 Andy Davies |