Field Names in Processing Trick
GCC Consulting
gccconsulting at comcast.net
Mon Nov 13 13:27:45 PST 2006
> -----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: Monday, November 13, 2006 3:37 PM
> To: filepro-list at seaslug.org
> Cc: bob at midcityoffice.com
> Subject: Field Names in Processing Trick
>
> Hi
>
> I must have missed this if it was on the list before, but
> today I found I could assigned a variable, FldName, to hold
> the Field Name as it appears in Define Files. @wef*, I could
> prompt the user a each field with the Field Name( starting at
> Field 4). In my example that follows, I'm prompting the user
> to Enter the Name, Address and so on at each particular
> field, when adding a new customer to the customer file. The
> file has 61 fields, so this saved me lots of typing. Also,
> using the selection set, called b1browse, displays a
> different prompt if the user is in fields, 31,39,42,43, and
> 45, save more typing.
>
> Sorry about the odd characters in the example below.
>
>
> +-------------------------+ 5
> | D E F I N E F I L E S |
> +-------------------------+
> Number -------------Field Heading-------------- Len --Type-
> 1 - MasterCustNo ? 6? rjfill0
> 2 - IntCustNo ? 6? rjfill0
> 3 - CreateDate ? 10? mdyy/
> 4 - Customer Number ? 10? allup
> 5 - Customer Name ? 35? allup
> 6 - Address Line 1 ? 35? allup
> 7 - Address Line 2 ? 35? allup
> 8 - Address Line 3 ? 35? allup
> 9 - City ? 20? allup
> 10 - State ? 2? stprov
> 11 - Zip Code ? 10? zipna
> 12 - County ? 25? allup
> 13 - WebSite Address ? 70? *
> 14 - A/P Contact ? 35? uplow
> 15 - A/P Phone ? 14? phone
>
> etc.
This feature has been available since version 1.
However, the field names MUST be contiguous.
Your Zip code - Zip_code
Customer Number - Customer_number
The simplest way is to edit your map by adding an underscore to those fields
you wish to use by name.
i.e amount=qty_shipped*cost is clearer the 10=5*8 (not referring to the
above map)
The one thing to be careful of is that you don't declare a long variable
with the same name as your field name. This may cause unwanted results.
You can't use the long name in lookups - ab=foobar(masterCustNo) will not
work. Although it may sometime in the future.
Richard Kreiss
GCC Consulting
More information about the Filepro-list
mailing list