I have a procedure that creates an export file to be read in Mail Merge. The data form has about 60 records.

There are two problems:-

1. If i set it up
For Form

list records

any form with ( field name = form field name ) field

any field ;

I only get the first record.

I therefore tried a dummy form without the export function, that still only gave me the first record,

but by changing any for all i get all the records.

2. If I then replaced the export file using the all criteria i then get the following message:-

Export to "c:\Data8M\MergeFolio.csv" .
.form header
CurrentDate,Current time,Fol

With fear of having misunderstood what you are trying to do.

The Export function in DFW DQL has its own special format and limitations.

Example 2

for MEMBERS ;

list records

LAST NAME .

for RESERVATIONS

list records

TOTALDUE .

end

end

export to "a: \MEMTOTAL.TXT" .

.form header members .items

.form header reservations

@f[1,1]~ @f[2,1]

.end

If you have a nested data structure simply use to For loops inside each other with their own individual List Records and you can then reference columns from both of them in the export format as above.

However, we don't recommend this export function.

In DataEase 8 you can export a CSV directly from ExecDQL() by simply adding a export file as the fifth parameter in the function, then it will export the list records in a flat DataEase specific CSV file.

If you need a specific format we recommend that you build it with WriteToFile() and MemoWriteToFile().

Both functions can Write/Append to a text file so you can build it dynamically.