topic Re: Creating QVD in App Development

Creating QVD

Motorsport28 — Mon, 21 Oct 2019 11:42:33 GMT

Hi guys

Im hoping someone can help. Im trying to create a QVD from a table which i have given the name Ëmployees but keep getting the error that employees cannot be found?

Re: Creating QVD

thi_pham — Mon, 21 Oct 2019 11:48:20 GMT

Your load statement miss of specified data source.

Such as:

Load fields Resident tablename.

Load fields;

Sql select ...

Re: Creating QVD

Motorsport28 — Mon, 21 Oct 2019 11:50:39 GMT

Hi TI

So i have the SQL Statement i have attached a complete screenshot

Re: Creating QVD

thi_pham — Mon, 21 Oct 2019 11:56:41 GMT

The sql statement should be located right after load, like:

Load fields;

Sql select fields from datatable;

Re: Creating QVD

Motorsport28 — Mon, 21 Oct 2019 12:09:13 GMT

Thanks for you help!

I placed the script beneath the sql select statement and it worked! Much appreciated

Re: Creating QVD

marksouzacosta — Wed, 26 Aug 2020 12:58:00 GMT

Hi,

We just released a new video in our YouTube channel that may help others looking for some extra info on how to create QVDs. I hope it helps!

IPC Global Tips #6 - Creating QVDs - Regular and Incremental Loads
https://youtu.be/S9L6vWItchs

Regards,

Mark Costa