>>Yes, Insert-SQL is better then APPEND+REPLACE just because you stremline two steps into one with all implications to data integrity, primary/foreign key values, RI triggers, etc.
>
>That's a good point. I don't have any of that fancy stuff right now, but in the next version I plan on using a database and that'll become important.
>
>I found a place where using insert-sql would have helped. I selected an alias, not realizing that I had never opened that table, and appended to it. It kept appending to the wrong table. Took me a while to figure out it was because it couldn't carry out the selecting of the work area. If I had done an insert-sql, it would have stuck it in the right table. :)
>
>Thanks,
Ok. Just a reminder: APPEND, REPLACE and some other 'xbase' commands have IN clause which allows to specify alias (just to make sure that it will affect right table).
Edward Pikman
Independent Consultant