Store and Where

[vivientexier]

Hello,

Is it possible to "STORE" in order to create a QVD and limit records by a WHERE clause.

[Peter_Cammaert · Accepted solution]

No.

Prepare and filter your RESIDENT table before you STORE it. However, you can omit or rename individual fields when storing a table.

Peter

[dvasseur]

Hi,

No, it's not possible.

The only way is to:

• create a new table (use NoConcatenate) with the WHERE clause
• store it
• drop the created table

[#4]

you store the loaded table, you can limit the store by reloading the wanted table to a temp table with a where clause and then immediately dropping it when storing is done.