>I have read several places where I should not use the APPEDN FROM commnad in code. They suggest that this is a command window command. What else should I use? I have used INSERT-SQL for one line of MEMVAR. This does me no good when the table I have has numerous records in it and I don't know how many. I tried the ARRAY thing but never really have a lot of success with that. What else can I do?

Depends on what you are trying to accomplish and what type of module you are working into IMO? If you are working with physical table as a source then APPEND FROM is a perfect statement to use. Be cautioned though that APPEND FROM without DBF() clause does not recognized newly changed fields and inserted records for source tables which are buffered until it were committed.