I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

formatted memo question

formatted memo question in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: formatted   question   formatted memo   formatted memo question  
Klepsis
Austin, TX USA

I have a form field which I would like to use to modify a formatted memo table field without giving the user direct access to the underlying table.  I can get the table field to display in the form field, but when I try to update it the formatting doesn't seem to work.  (tab and enter keys take me out of the form field).  I have tried both undefined and defined field creation and the only difference is that I have to press F9 when entering text into the defined field version.  How do I enter formatted text into this field?

 Posted 63 days ago (Thread Starter)
Comment Quote
About Klepsis -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17570, 7 replies
Thread Started 6/21/2019 8:13:03 AM
View Counter=43
Last Reply Posted 6/22/2019 1:55:53 PM)
Location=Austin, TX USA 
Joined=26 months ago   MB Posts=10  
Moderator
Steven.G
Myrtle Beach, SC USA

in the properties of the memo field on the form, you can change the font and attributes, and that might be all you're looking for

but if the point is to copy/paste formatted stuff from other places (Word, Excel, etc), some modern platforms don't transfer 100% correctly

formatted memo fields can be VERY problematic, when heavily edited, over time.. if possible, avoid them

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 63 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17577 (Level 2) and Parent is 17570
Reply Posted 6/21/2019 8:35:49 AM
Location=Myrtle Beach, SC USA 
Joined=35 months ago   MB Posts=300  
Klepsis
Austin, TX USA

Maybe I didn't explain the issue clearly.  I don't want to copy or paste things from other soruces.  I am trying to enter or modify the comments in a memo field in an existing table using a data entry field on a form.  The font property only chooses a particular font and font size.  This would help align columns only if the font were something like courier new.  Not what I'm after.  There does not seem to be any 'attribute' tab in the properties pop-up, and nothing in the pop-up that references using the tab key for horizontal spacing, or the enter key for next line within the memo field.  Nor can I find any reference in the Help function that would assign the "formatted memo" data type to the display field.  The end result should look like there are two columns of info, separated by tabs, with some additional comments either above or below them.  If I'm updating the field directly in the table in edit mode (F9) I can do that.  When I try it on the form, both the tab key and the enter key move me to the next field on the form.  When I modify the keyPhysical method trying to insert a tab or next line value into the field, I get the /t or /n literals inserted into the text. I am at a loss to figuring out how to make the display field behave like a formatted memo.

 Posted 63 days ago (Thread Starter)
Comment Quote
About Klepsis -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17581 (Level 3) and Parent is 17570
Reply Posted 6/21/2019 10:03:57 AM
Location=Austin, TX USA 
Joined=26 months ago   MB Posts=10  
Moderator
Steven.G
Myrtle Beach, SC USA

yes, that's a much more specific question :-)

either way, form or table, you should be able to  hit Field View (F2), or pick Field View from the menu

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 63 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17582 (Level 4) and Parent is 17570
Reply Posted 6/21/2019 10:32:11 AM
Location=Myrtle Beach, SC USA 
Joined=35 months ago   MB Posts=300  
Klepsis
Austin, TX USA

Well, if the field is a defined field, pressing F2 and starting to type getss me a message that I should press F9 to be in edit mode.  Typing then updates the table field directly, but it still doesn't let me enter a tab or nextline key.   When the field is an undefined field pressing F2 doesn't seem to make any difference.  After doing a little more reading in the Help function, I'm thinking at this point that I should go back to the keyPhysical method and try appending the VK-TAB or VK_RETURN values (instead of "/t" & "/n" literals) to the existing field contents.  I'll let you know if that works or not.

 Posted 63 days ago (Thread Starter)
Comment Quote
About Klepsis -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17583 (Level 5) and Parent is 17570
Reply Posted 6/21/2019 11:30:39 AM
Location=Austin, TX USA 
Joined=26 months ago   MB Posts=10  
Klepsis
Austin, TX USA

Ok, update to last comment.   That resulted in the numerical value of the key event being appended to the data.  So, no different from forcing a "/t" into the data.  I would have thought that if there is a formatted memo type indicator (F) available when you are creating the table structure that here should be a formatted memo data type available when you are generating the Var, endVar portion of a form or method.  But if there is, I can't find any reference to it in either the objectpal help or the manuals.

 Posted 63 days ago (Thread Starter)
Comment Quote
About Klepsis -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17584 (Level 6) and Parent is 17570
Reply Posted 6/21/2019 2:06:12 PM
Location=Austin, TX USA 
Joined=26 months ago   MB Posts=10  
Moderator
Steven.G
Myrtle Beach, SC USA

the data entry behavior, for memo and formatted memo, are essentially the same in a raw table session.. when you go to the field in edit mode, and hit F2 or Shift-F2, you get a "notebook" kind of screen.. you're in Memo View mode.. you're entering raw text, which includes tab, enter, and all the other ascii characters

but on a form, F2 puts you in Field View mode, Shift-F2 puts you in Memo View mode.. for a formatted memo field, that's not the same.. you need to be in Memo View mode to use tab, enter, and all the ascii stuff

but the point remains, you're still just entering the same "text" stuff, either way.. the purpose of the "formatted" memo, and all the other BLOB field options, was to allow it to contain stuff that paradox itself could not create.. that's one of the things all the "read to/from file" commands are for

over time, we found out that all of this BLOB stuff was mostly a really bad idea

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 62 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17586 (Level 7) and Parent is 17570
Reply Posted 6/22/2019 7:22:53 AM
Location=Myrtle Beach, SC USA 
Joined=35 months ago   MB Posts=300  
Most Recent Post
Klepsis
Austin, TX USA

OK.  The Shift F2 makes it work like I thought it should.  I'm sure that that is somewhere in the reference manual and I've been glossing over it.  I'll need to include a text reminder on the screen above the field in order to have the users update the field properly, :-)  but that's no biggie.  Thanks for the help.  

 Posted 62 days ago (Thread Starter)
Comment Quote
About Klepsis -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17587 (Level 8) and Parent is 17570
Reply Posted 6/22/2019 1:46:09 PM
Location=Austin, TX USA 
Joined=26 months ago   MB Posts=10  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1236A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17570 Counter
43
Since 6/21/2019
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech