• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Problems using SQL to blank out LNGP on F0101

magpie

Active Member
Having more than 4,000 customers with LNGP = E is causing problems with column headings on their statements. I would like to use SQL to blank out the LNGP where = E on F4101.

Using the CR application, I noticed this field is on many other tables. Just wondering if anyone else has had to do a mass update of this field on F4101 using SQL and if it caused any problems?

This is in an 8.0 environment.
 

magpie

Active Member
The title of the post is correct, it's F0101. In the detail, I mention F4101. This is wrong, should be F0101.
 
Last edited:
Top