wordwrap

[GCC Consulting]

> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
> elestial.com] On Behalf Of bobsimcoe at adelphia.net
> Sent: Wednesday, August 09, 2006 2:03 PM
> To: filepro-list at seaslug.org
> Subject: wordwrap
> 
> Hi
> 
> Just agreed with my boss to develope a filepro program for 
> our office furniture business. It will include the accounting 
> and office furniture sales functions. I'm currently the 
> accountant for this company, but I've been working with 
> filepro (profile) since the early eighties.
> 
> Currently, on another job, I work with filepro 5.0, Windows 
> Server 2003 and Terminal Services. Here, at the furniture 
> company, we plan to purchase fp5.6 with SQL and ODBC, I'm 
> testing the evaluation copy of these now, and I'm very excited.
> At this time we use a character based application based in 
> UniData. It does have a nice, very functional interface 
> called wIntegrate, but the sales people and others here, 
> never use any of the functions, except for printing the 
> screen occasionally.
> 
> I know I can make filepro do almost everything I need to, but 
> I know I'll have questions on the BEST WAY to do things. 
> 
> My past applications all work the same, whether I'm UIAing a 
> customer, applying cash to accounts receivable,  or preparing 
> a sales quote, I'm always on a standing file ( I think that 
> the term I've seen used here ), in -xa.
> 
> My question to the list is: When preparing a sales order / 
> quote, sometimes when manually adding the item description, 
> it can be many lines. I plan to allow at least 20 description 
> lines per line item, 40 characters wide ( 1 detail record ). 
> Six of those lines would be visable on the input screen, and 
> appear to scroll up and down as needed, with some sort of 
> word wrap working on the description data entry.
> 
> The wordwrap is my problem.
> 
> Would the new WORDWRAP & @WORDWRAP commands develope a better 
> wordwrap ?
> 
> Could the BLOB command be used with NotePad ?
>  (I have no clue how BLOB words, or what it does)
> 
> Does anyone have a slick wordwrap routine for sale ?
> 
> 
> Any help or direction would be greatly appreciated.
> 
> Thanks
> Bob Simcoe
> MidCity Office Furniture
> Buffalo, NY

The advantage of using the new wordwrap functions available over using the
memo function in your case is control over the size and placement on forms.

You can even make use of the spell checker option in 5.6.

The function you would use if you did not use wordwrap is the memo command
not blob. The memo is stored in the blob.  You would define a real field as
(16,memo).  See memo syntax below:

Syntax:

Then: MEMO xx delete

Then: MEMO xx clear

Then: MEMO xx edit [(row, col, height, width [,startrow, startcol] )] [WRAP
| NOWRAP] [READONLY] [TITLE]

Then: MEMO xx export filename

Then: MEMO xx import filename

Then: MEMO xx show [(row, col, height, width [, startrow, startcol ] ) ]

 

If: MEMO 

If: NOT MEMO 

You can also print a memo on a form or report.  However, controlling the
size (length and width) is difficult as there is not option to limit the
length o fthe text.

Using real fields of 40 characters and x number of them allows for better
control of both width and length(# of text lines).

Richard Kreiss
GCC Consulting