Arrays

Kenneth Brody kenbrody at spamcop.net
Tue Jun 25 14:42:15 PDT 2013


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


More information about the Filepro-list mailing list