On one of my databases, I think it was when we updated from 10 to 10.5, the Ctrl-enter that they had used to do carriage returns in fields were turned into physical characters exactly as you show. I had to look up all the columns that were affected and run this piece of code. Fixed it up! And the normal method of ctrl-enter worked for new entries. So question 1 for you would be: does this issue happen only on existing data? If you enter new data does it print okay?
First: I typed "unload data for <table>", looked for the "set lineend" line. I then did a copy / paste of the character into the following program (the vText variable) You don't really need a declare cursor for this, just one update would do, but they wanted to manually view and confirm each record that was changed. setvar vtext = 'þ' <-- this is the lineend character set var vcr = (CHAR(013)+ CHAR(010)) sel ordid, shoporder, custreq from orditems where custreq contains .vtext DROP CURSOR c1 DECLARE c1 CURSOR FOR SELECT ordid, shoporder FROM orditems where custreq contains.vtext OPEN c1 WHILE 1 = 1 THEN FETCH c1 INTO vordid, vso IFSQLCODE = 100 THEN BREAK ENDIF show var vso UPDATE orditems SET custreq = (SRPL(custreq,.vtext, .vcr, 0)) WHERE ordid = .vordid edit shoporder, custreq from orditems whereordid = .vordid ENDWHILE Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: [email protected] <[email protected]> Sent: Thu, Jun 4, 2020 8:14 pm Subject: [RBASE-L] - Line Feed/Carriage Returns in Report BLOB Fields #yiv6158320424 blockquote.yiv6158320424cite {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;}#yiv6158320424 blockquote.yiv6158320424cite2 {margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px solid #cccccc;margin-top:3px;padding-top:0px;}#yiv6158320424 a img {border:0px;}#yiv6158320424 #yiv6158320424 #yiv6158320424x2af7a3d97d2c42aeb487014637601461{font-family:'Segoe UI';font-size:12pt;}#yiv6158320424 #yiv6158320424x994c76c025d9404 #yiv6158320424xce0a6bc6429748f68a1fbd60505e23fd, #yiv6158320424 #yiv6158320424x994c76c025d9404 #yiv6158320424xce0a6bc6429748f68a1fbd60505e23fd #yiv6158320424x0ffa9ca747a0444 #yiv6158320424x5341b55c703f4d708da1fcccafdd6cf1, #yiv6158320424 #yiv6158320424x994c76c025d9404 #yiv6158320424x86b4dd35dfc94ef5a5432fdb70f5f643{font-family:'Segoe UI';font-size:12pt;}Question: This is representative of the text formatting entered into, and visible in a field of file type NOTE or VARCHAR within the BLOB Editor: SET SCREWS|1/4-20 x 3/8in|Qty 3 per set In BROWSE MODE, or in a Report, the data appears formatted as: SET SCREWSþ|1/4-20 x 3/8inþ|Qty 3 per set ... where (þ = 0AFE). What codes need I enter at the end of each text line such that a [line feed|carriage return] formats the text correctly within a report printout? Thanks much, Bruce Bruce A. ChitieaSafeSectors, Inc.112 Harvard Ave #272Claremont CA [email protected]+011 (909) 238-9012 c+011 (909) 912-8678 f -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em8421a99a-c91e-4aee-9c50-b92cc81c1ca6%40pathfinder. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1226231496.3520413.1591365166104%40mail.yahoo.com.
