Hi,

I'm looking for advise on copying data between companies in Baan.

The script I'm working with (which copies item data) selects the data from the source company into variables, then updates or inserts with the contents of these variables. This works fine, but the code is very long as there is a single variable for each field of the table. I'm looking for some way to shorten this.

I know it is possible in some dbs to store an entire row in an array or other structure and insert that. Is there an equivalent to this in Baan?

Thanks,
RD

You can use the record buffer rcd.tablename and tablename._compnr to copy records to another table. I would search on "_compnr" and start checking the various posts. Not really sure of a good answer. Also if you post your code someone might see other solutions.

I have written code to do this...I don't know how to attach a file to these response and the code is too long to paste in here...if you like for me to send to you send me a reply to my email I can send to you...email addy is sdiehl@howdenbuffalo.com