I don't get it.
appending from array works in VFP as I said here. I think the original question doesn't refer to SQL server.
I don't know what you mean.



>

>While multiple row insertion is allowed in SQL-server; this is not so in VFP (sigh).
>In SQL Server: This works!
>CREATE TABLE #test (fld1 nvarchar(10))
>INSERT #test SELECT fld1 FROM test2 where fld1 = 'TEST'
>

>This will insert all records FROM test2 INTO test meeting the criteria.
>
>>you need to SCAN the table or, if they are not too big and they are same structure
>>you can do:
>>

>>SELECT alias1
>>copy to array aAlias1
>>SELECT alias2
>>APPEND FROM ARRAY aAlias1
>>

>>
>>>hey everyone,
>>>here is the problem. it is like the previous one i have posted but with a new twist. the first problem was a different angle on trying to solve this one. here is the scenario:
>>>
>>>i have to table i have set up as alias.
>>>alias1 and alias2
>>>
>>>i then preceed to excecute the following code:
>>>select alias1
>>>insert into alias1 ;
>>> fields ;
>>>values alias2->fields
>>>
>>>the problem is that i only insert one record into alias1 from alias2 when i want to insert all alias2 records. what am i doing wrong?? any suggestions would be appreciated. thanks.