Skip to Content
0
Former Member
May 10, 2008 at 01:56 AM

Moving data between tables (how to find out if the 2nd table is empty)

20 Views

Hi,

I have 2 tables, and I'm copying records from one table to another.

I've followed the Wiki: [https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/movingdatabetween+tables]

So far, everything works ok.

Here is my question: how do I get the number of records passed?

I mean, how do I know the number of rows in the 2nd table? (Remember that this number is variable, because it depends on how many rows I've inserted and deleted on the 2nd table).

I've tried to achieve that using a data store with a numeric field, but I couldn't find the way to increment/decrement the numeric field on data store, and insert/delete the row on table at the same time .

All I want is to find out if the 2nd table is empty or not.

Any ideas to solve this?

Thanks in advance!

Help will be point-rewarded.

Marcelo