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/
