I use this an Exit EEP from a Note field, maybe you could check for '^^^^^^'. Give the user a warning, let them delete the blank lines then save the data?
SET VAR vxxsubj NOTE = NULL SET VAR vxxsubj = subj IN ptsoap WHERE ptspid = .vptspid IF vxxsubj CONTAINS '[' OR vxxsubj CONTAINS ']' THEN PAUSE 1 USING + 'Proof read the text it contains [ or ] ' &vpopt ENDIF ________________________________ From: Tom Frederick <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, August 20, 2014 3:05 PM Subject: [RBASE-L] - Checking too many RETURNS Almost all of our screen use NOTES to add paragraphs of text info. These case notes can be very long depending on the situation. It works very well. What I cannot control is an ENTER button being hit 200 times. I assume some heavy enough item was laid on the ENTER key for a while. Our reports all get converted to PDFs for storage. Had a report today that was 37 pages (normally about 15 pages), but was blank after the second paragraph so staff were saying there was no info. Looking at the data in NOTE/VARCHAR quickly showed the first line as expected then over 200 blank lines. Deleting the 200 lines fixed the problem. There was nothing indicating those lines were not NULL and LINEEND is set as '^'. I could go to individual lines on the NOTE/VARCHAR page so I knew where the problem was. Does R:Base have a command to turn on background commands like in Word to find these items or is there some way to automatically check for say '^^^^^^'? This is the second time this has ever happened. Easy repair, but how can I catch this problem while users are working? Tom Frederick President/CEO Elm City Center 1314 W Walnut Jacksonville, IL 62650 O-217-245-9504 F-217-245-2350 [email protected]<mailto:[email protected]>
