SmartConnect remove single quotes in GlobalLastError

If your GlobalLastError has single quotes in it, you won't be able to (easily) save it back to the source table with SQL

This article describes the work around. 

Discerning viewers will note that this is the exact same piece of code as the previous article (smiles)

I need two articles because they're different problems and I need to put them on the SmartConnect menu. Sorry for the spam. 

dim LastError as String
LastError = GlobalLastError
GlobalLastError = GlobalLastError.Replace("'","")
return true

 



RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences