Store current selections dataset to file

[#1]

Hi, everyone.

I've get following issue: let's assume that my QV file contains only one table ("work_table"), I made some restrictions and want save rows of "work_table" which are matching current selections into a file.

How can I achieve this?

Best regards.

[Anonymous]

Is an export not working for you?

Just right click on the obkject and choose export.

[#3]

No, "Export" will return only resulting dataset.

Even if I'll create a table box including all fields, I will miss duplicate rows (which exist in the source data): executing in the script following statement "STORE * from work_table into file.csv (txt); " produces file with 33k rows, but when execute command "Export" (with no restrictions) resulting file consists of only 8k rows.

So that is not a solution 😞

[rwunderlich · Accepted solution]

Add a row unique value to work_table in the script

recno() as Recno

and then add Recno to your table box.

-Rob

[#5]

Well this is not exactly what I need, because generated csv file should be used further by another application, so I have to propose to make changes there and this probably would be difficult.

But I agree that this approach is good for my issue.

Thank you, Rob.