RowsCopy

[extempore]

Hi all,

I have 2 dws (dw_1 and dw_2) for which I am trying to do a rowscopy from dw_1 to dw_2. I am getting a return code -1 all the time. What could be the reason? This is my code:

Long llRow
Integer i, j, liReturn, liRowsCopy, liRowsMove

IF dw_1.RowCount() > 0 THEN
FOR i = j TO dw_1.RowCount()
llRow = dw_1.GetSelectedRow(i)
IF llRow > 0 THEN
liRowsCopy = dw_1.RowsCopy(llRow, llRow, Primary!, dw_2, 1, Primary!)
j = j + 1
ELSE
EXIT
END IF
NEXT
END IF

Thanks in advance.

 

[royjimenez]

the dataobjects must be the same ( its structure )

liRowsCopy = dw_1.RowsCopy(llRow, llRow, Primary!, dw_2, dw_2.rowcount() + 1, Primary!)

 

[extempore]

Thanks a bunch. Second DW had one additional column. Thanks again.

 

[eri232323]

Hi Everybody,
I need store some data from a database into an other.
I try pipeline, rowscopy, and step row by row, but it's so slow i think.
Does anyone know something what is faster like these?
(Pipeline was the best slower:-(
erie