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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Jude 3/25/2018 4:15:27 PM

Parse a text string into the comment fields in SOP10106

* This article, and all our great .NET Development documentation, Is available on the .NET Development menu

On first glance, you might say 'that seems too easy to write about'... but give it a thought. 

If you have a custom text box:

And you're storing the content into SOP10106, you have to break it into 4 strings, (COMMENT_1, etc.) and then store the entire text in CMMTTEXT.

In the example above, we just parse on the vbCRLF chars and go on. But what about this one:

64 words, 419 characters. No vbCRLFs. What logic do we use now? We'll cover that. 

4Penny.net
Version: All
Section: Visual Studio Tools for Dynamics GP,VBA,.NET Development






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