>>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.
>
>What I mean is that, you have a valid requirement that is NOT available in VFP but DO work in a database server. Who knows, this thread may end up in the development inbox of the MS VFP team and 'just might' add this capability sometime in VFP's future...
It's already there, or nearly there, just doesn't use the 'push' direction, it's rather 'pulling'. In xBase world, it's quite common to Append From {table} [for...][while...], where {table} is a filename (not an alias - but you can put dbf('alias') to get the filename from the alias). So this partial incompliance with the SQL standard is not considered to be a flaw of any significant size. Though, it would be nice to have the Insert improved - to do multiple records, have a For/While clause etc etc.