General information
Category:
Coding, syntax & commands
Jim,
As always, you are right.
But below I had snipped an EARLY portion of the Help. . .
--------start of snip-------
Arguments
ArrayName Specifies the name of the array that contains the data to be copied to the new records. New records are added to the table until all rows in the array are appended.
------end of snip-----
It is much further down that the "conditions" regarding 1/2 dimensional arrays is written. I cannot blame someone for dashing off and expecting many records after reading just the start of the Help.
Little thing, I know, but they mean a lot in the long run.
Cheers,
Jim N
>>Hi,
>>
>>I'm attempting to append from an array into a cursor. All I'm getting is the first row in the array. According to the help on VFP, APPEND FROM ARRAY is supposed to insert a row for every row in the array.
>>
>>Here is my 'test' code:
>>
>>DIMENSION laTest(3)
>>laTest(1) = "1"
>>laTest(2) = "2"
>>laTest(3) = "3"
>>CREATE CURSOR cTest (TestField C(1))
>>APPEND FROM ARRAY laTest
>>BROWSE
>>USE IN cTest
>>
>>Any suggestions?
>Jim,
>
>Read the help a little more carefully. If an array has only 1 dimension it will put the value of each row into the corresponding field of one record. If the array has two dimensions then each row in the array will become a separate record in the table with each column being a field.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only