DataBase table count

[#1]

Hi all,

I have a tricky requirement.

I am extracting a table from DB and storing into QVD. (works fine till now)

when the table crashes in DB and qvw reloads then we will get zero records . Is there any way if the table crashes/deleted the dashboad should get the previous records?

Hope to get some solutions and pls share sample app

[jagan]

Hi,

Try this script

TableName:

LOAD

*

FROM DataSource;

If NoOfRows('TableName') > 0 THEN

     STORE TableName INTO QVDFileName.qvd;

END IF;

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks Jagan

what if table is empty then the qvd should store the old data

could you specify this logic pls

[jagan]

Hi,

If the table is empty we are not updating the QVD with the empty table, so you will get the old data from QVD since is not replaced with the latest one.

Regards,

Jagan.

[#5]

Thanks jagan

hope to see you back