>>>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?

Just a reminder that APPEND FROM does have a FIELDS clause that lets you name the specific fields.