Arrays

[Richard Kreiss]

> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Tuesday, June 25, 2013 5:42 PM
> To: Richard Kreiss
> Cc: 'filepro-list at lists.celestial.com'
> Subject: Re: Arrays
> 
> On 6/25/2013 5:24 PM, Richard Kreiss wrote:
> > Same client:
> >
> > filePro 5.6.10
> > Server: windows Server 2008
> >
> > I have a number of routines that post data from on file to another where
> arrays are mapped to the sequential fields on the current file and an array is
> mapped to the matching fields in the other file.
> >
> > Dim foobar(22):1;dim newfile(22):file(1) Lookup to newfile free
> > ::Ct="1"
> > Loop_po:ct lt "22":newfile[ct]=foobar[ct];ct=ct+"1";GOTO loop_po
> 
> FYI -
> 
> If both files have 22 fields, a "copy newfile" would most likely suffice.
> (Unless you have a field which is zero-length in one file, and not in the
> other.)
> 
> > The above has worked well for a couple of years.  Recently it has not been
> working properly.  By that I mean, some fields values are posted and other
> not. Phone numbers and date fields are not being posted.
> >
> > The data is being imported from a csv file and then formatted to filePro
> field edits before being posted to the first import file.  The import is checked
> and them posted to a second file during which more data is added before
> posting the actual working file.
> 
> Can you give some specific examples of actual data in the current file (along
> with the field definitions) that ended up being blank in the posting file (along
> with the field definitions).
> 
> > I modified the posting file to not use the arrays.
> [...]
> 
> Are you saying that replacing the arrays with explicit assignments made it
> work?
> 
> --
> Kenneth Brody

These are the primary fields.  These are many more fields which are posted not using the array.  Then there is another set of arrays for posting 15 more fields.

Richard