Dave Crozier wrote:
Ted,
I've used Sys(2015) for a long time in all my apps for temporary cursors and
I've never had a problem so I'm very interested in the fact you say that
invalid cursor names can be returned. When and under what circumstances?
I'm interested in hearing your answer too. I use SYS(2015) many times
in combobox recordsources when I use RecordSourceType=3 (SQL
Statement). For example, I use "select cName, iid from MyViewOrTable
into cursor sys(2015) order by cName" for the recordsource.
I do agree however that reports should be pre-processed with SQL Selects in
order to produce a single cursor when possible.
Absolutely...life is much easier when you can use a single cursor for
the report's source. Makes it easier to issue a COPY TO out to a table
so that you can check things when debugging too, imo.
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** 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.
