Thanks, Ross. Actually when we were looking for our reporting solution a couple of years ago we looked at the available 'native' U2 products and, for various reasons, decided against them in favor of Crystal Enterprise. Your reference to "The Drumheller Trick" sent me Googling, but also set the wheels turning in my head. Maybe, just maybe... Thanks again.
Jim --- Ross Ferris <[EMAIL PROTECTED]> wrote: > Jim, > > Probably way tooooo late in the day, but there are a number of non-ODBC/OleDB > solutions that > might have solved this problem for you. Names like mvQuery, Informer, and our > own > Visage.Reporter come to mind. > > I assume the other products have something similar to our facility where you > can CALL a > subroutine that returns a list of ID's to be processed, and we don't really > care HOW the list is > generated in the first place. > > So, as to the problem at hand, would a variation of the "Drumheller Trick" > work ? SO that you > operate on a file with a single, known key, BUT the field that you return is > actually the result > of a subroutine which has the necessary logic in it to manipulate your select > lists - and from > there traverse to the "real" file ? > > Never having played, not sure if this would work, but perhaps may trigger a > thought in those > with more first hand experience > > Ross Ferris > Stamina Software > Visage - an Evolution in Software Development > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:owner-u2- > >[EMAIL PROTECTED] On Behalf Of Jim Bullock > >Sent: Tuesday, 15 March 2005 9:55 AM > >To: u2-users@listserver.u2ug.org > >Subject: [U2] UD: ODBC/OleDB access to selected records in a file > > > >We are having quite a bit of success writing reports with Crystal Reports, > >using ODBC to access > >our UD6 database. We have gone through the exercise of flattening files, > >creating new dicts, etc. > > It's slow, but we are usually able to get what we need. We serve up the > >reports to the users > >with Crystal Enterprise and Apache. > > > >We are not, however, able to take advantage of one (IMHO) of the most > >powerful features of a U2 > >database, the ability to manipulate sets of id's through the use of SELECT, > >SAVE.LIST, GET.LIST, > >MERGE.LIST, etc. We have a very large library of UniQuery paragraphs which > >do multiple selects on > >multiple files, saving foreign keys, eliminating duplicates, etc., to > >arrive at a final savedlist > >of id's of records to be put on a report. Currently we use this list of > >id's to write a report in > >UniQuery. We would love to be able to write this report instead in Crystal. > >There would be no > >SQL SELECT at all in the Crystal report, the selection of the proper > >records having already been > >accomplished by the server-based procedure. > > > >The natural, or so I thought, place to do this sort of thing is in a stored > >procedure. I got as > >far as "seeing" the stored procedure name via the OleDB driver, but was > >unsuccessful in actually > >"seeing" any data. Many e-mails and phone calls with our VAR and IBM later, > >we were pointed to a > >place in the UD documentation where it says stored procedures are not > >supported by UniData. > > > >We have racked our brains and have been unable to come up with a workaround > >for this gaping hole > >in the ODBC/OleDB interface to UniData. Before we give up entirely and > >resign ourselves to > >putting out paper reports with UniQuery, I thought I would ask this group > >if anyone has solved > >this problem. Anyone? > > > >Thanks in advance, > > > >Jim > > > >"...a livable wage is a moral value. Affordable health care is a moral > >value. A decent education is a moral value. A common sense foreign policy > >is a moral value. A healthy environment is a moral value. The feeling of > >community that comes from full participation in our democracy is a moral > >value. It is a moral value to make sure that we do not saddle our children > >and grandchildren with our debt." > > > >-Howard Dean > > > > > > > >__________________________________ > >Do you Yahoo!? > >Yahoo! Mail - Find what you need with new enhanced search. > >http://info.mail.yahoo.com/mail_250 > >------- > >u2-users mailing list > >u2-users@listserver.u2ug.org > >To unsubscribe please visit http://listserver.u2ug.org/ > > > > > >-- > >No virus found in this incoming message. > >Checked by AVG Anti-Virus. > >Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > "...a livable wage is a moral value. Affordable health care is a moral value. A decent education is a moral value. A common sense foreign policy is a moral value. A healthy environment is a moral value. The feeling of community that comes from full participation in our democracy is a moral value. It is a moral value to make sure that we do not saddle our children and grandchildren with our debt." -Howard Dean __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
