WAG: Sounds like the wrong table/cursor is selected. Is it possible you
have a grid somewhere in the mix with 4000 records in its recordsource?
If so, before running your export code, set focus to a control other
than the grid.
Frank.
Frank Cazabon
On 14/09/2017 05:28 AM, Alan Bourke wrote:
I'm creating Excel output using the XFRX driver. The basis for the
report is a cursor which has in my test setup about 40 records. It's
created using SQL Select with the nofilter clause. There are no
relations in to it or out from it. It is the currently selected table
when running the report.
The issue is that the XLSX file produced just has the same record
repeated about 4,000 times.
Any ideas?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.