Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Points: 6716

1/14/2019 2:10:58 PM

SmartConnect remove single quotes in GlobalLastError

* This article, and all our great SmartConnect documentation, Is available on the SmartConnect menu

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.
Version: Unknown or N/A
Section: SmartConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables