PRB: APPEND FROM ARRAY Creates Only One Record
Article ID: 119635
Article Last Modified on 5/6/2003
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft FoxPro 2.6 Standard Edition
- Microsoft FoxPro 2.6a Standard Edition
- Microsoft FoxPro 2.0
- Microsoft FoxPro 2.6 for MS-DOS
- Microsoft FoxPro 2.6a Standard Edition
- Microsoft FoxPro 2.6a Professional Edition for Macintosh
- Microsoft FoxPro 2.6 for SCO/UNIX
This article was previously published under Q119635
SYMPTOMS
The APPEND FROM ARRAY command should create one record in the currently
selected database for each row in an array. Occasionally, only a single
record will be created with the data from the first element of the array.
CAUSE
The array has been created as a one-dimensional array, as shown in the
following example:
DIMENSION myarray(40)
RESOLUTION
The array must be created as a two-dimensional array, as shown in the
following example:
DIMENSION myarray(40,1)
The ",1" causes the array to be created as 40 rows by 1 column. The APPEND
FROM ARRAY command will now function as expected.
Additional query words: FoxUnix FoxMac FoxDos FoxWin 2.50 2.50a 2.50b kbvfp300 kbvfp300b kbvfp500 kbvfp500a kbvfp600 2.50c
Keywords: KB119635