>>I'm trying to select a table from a method, but keep getting a message referring to an unknown object. Why would my program think the table I'm trying to select is an object? When I got the error, I went to the command window to see if the table was there and opened and it was.
>
>I had that error - it turned out I'd misspelled a field name. The error wasn't on the SELECT line, but the next line where it was looking for the field (Mytable.Myfield). The '.' in the syntax led VFP to look for an object when it couldn't find the table/field combination.
>
>HTH

Barbara -

I went back and looked at my SELECT statement, which as I mentioned was followed by an Append blank. But following that was a line with a syntax error (I'd used a table.field = table2.field2 instead of replace), so when I fixed that, the error went away. I appreciate you help. Do you have any explanation on why this kind of error (in my case 2 lines down) would cause VFP to report an error on the SELECT line?

Sylvia