>>Hi all,
>>what i am trying to do is copy the data from one database to another. what i do is work out if one has the same table as the other, and if it does i then copy the information from the corresponding fields into the new database.
>>my issue is, when you append blank in the new database and issue the replace statement, how do you specify from which database it comes from?
>>
>>thanks,
>>Jordan
>
>Can't you just use APPEND FROM to copy the entire table in one command? As to the origin, I think you can specify the full path.

i can't just APPEND FROM as there might be extra fields in either of the tables. i am copying just the fields that are similar to both.
can i use the DATABASENAME!tablename.fieldname syntax in the replace statement?