main logo
Subject: Re: SPT & Access Heck
Author: "Andy Davies"
Posted: 2005/04/30 07:16:54
 
View Entire Thread
New Search



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
<-- Prior Message New Search Next Message -->