We have an open support call on this subject but I wanted to tap into the developer's experience out there. We seem to be having trouble using the COPY_TABLE statement when attempting to do a DATA only copy.

Near as I can tell the only requirement is to specify "DATA.tablename]" in the source table parameter. It never seems to work for us. However, we do seem to be able to use the "DICT.tablename]".

This is OI 3.7.2 and we are using a Development system.

Any ideas? Thanks.

[email protected]

SRP Computer Solutions

When you use the DICT. or DATA. prefixes for the original table name, you must use the same prefix for the new table name.

Copy_Table( "[b]DATA.[/b]MYFILE","DATAVOL","MYAPP","[b]DATA.[/b]NEWNAME" )

For those that are wondering why this requirement, is basically there for the little used user specification functionality.

The Sprezzatura Group

[/i]World leaders in all things RevSoft[/i]

Don-

For Data Only, try:

Copy_table('DATA.MYTABLE', 'C:\FOOBAR', @APPID, 'DATA.MYNEWTABLE', ,,,,,)

hope this helps-

Mike Ruane

Sprezz/WinWin,

Thanks for the info, it worked. BTW, Revelation also came back today with the correct answer.

[email protected]

SRP Computer Solutions

View this thread on the Works forum...