Does this email thread confirm that U2's OLE-DB has an issue with Crystal Reports 2008 (or any 'current version' of Crystal Reports)? Do it confirm that it is not working anywhere?
And to make sure I'm clear -- Tony - you are proposing a 'middleware' tool to make U2 do something that in theory it should be already intrinsic to the product - is that right? In my mind, if we generate the Schema, I'm thinking the OLE-DB interface should "do" what I'm wanting without a 3rd party tool - It works fine with other tools - I'm trying to figure out if we're just wrong (Crystal Reports works cleanly at X number of sites and we've made a setup issue ) or if we've found a 'true problem' - that no one can make Crystal Reports work WITHOUT buying something else. Thanks! DW ----- Original Message ---- From: Anthony Youngman <[EMAIL PROTECTED]> To: "[email protected]" <[email protected]> Sent: Wednesday, September 17, 2008 11:02:47 AM Subject: RE: [U2] [UD] Crystal Reports and UniData Exactly. Doing it WITHOUT an AS keyword (as is happening in my case) will cause it to blow up. Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 16:37 To: [email protected] Subject: RE: [U2] [UD] Crystal Reports and UniData Usually, the AS keyword is in use... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 10:18 AM To: '[email protected]' Subject: RE: [U2] [UD] Crystal Reports and UniData But won't it then disappear up its own backside with ambiguous field names? Iiuc, listing multiple file names does a cross-product, and as a result if you repeat the same file name, EVERY field will be ambiguous and the SQL will be unable to resolve. Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: [email protected] Subject: RE: [U2] [UD] Crystal Reports and UniData SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC could just as well read SELECT FIELDS FROM TABLE_ASSOC MY_SELECTED_TABLE It does conform to SQL... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, September 17, 2008 4:14 AM To: '[email protected]' Subject: RE: [U2] [UD] Crystal Reports and UniData I looked at that SQL and thought "what's wrong with double quotes?" (but then I don't know SQL that well). I thought quoting field names was mandatory if they contained spaces and optional otherwise. Or should it be single quotes and double is the problem? I'm still having problems with the doubled table name from MS Access ... does anybody know why Access will happily retrieve an ASSOCiation from UniVerse via a linked table, but as soon as you try and sort it, it doubles up the table name and causes UV to throw a wobbly? SELECT FIELDS FROM TABLE_ASSOC TABLE_ASSOC Is what it does and UV quite reasonably complains about the double TABLE_ASSOC :-( Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 16 September 2008 23:49 To: [email protected] Subject: RE: [U2] [UD] Crystal Reports and UniData David, the best approach may be more indirect. This is another reason why I keep trying to discourage the more direct interfaces between MV-specific SQL tools. Rather than trying to bind CR or any reporting tools to U2, create a Data Access Layer (DAL) that you're comfortable with using any tools you prefer. You can then use this with any future project and enhance it as you find the need. Then create classes for a Business Logic Layer (BLL) that represent the server-side data. These might include CUSTOMER, ORDER_HDR, INVENTORY, etc. Again, you will be able to use these for any future projects. Then you can create a final class, decorated with the .NET DataObjects attribute, that can be used as an ObjectDataSource with any tools that bind with such DataSources - including Crystal Reports. You will probably have a few of these for your various application needs. Not only is your effort on these classes portable to other projects, but you're abstracting matters of the UI (Crystal Reports and their API in this case) from any changes you make to accommodate DAL or DBMS changes. For example, you can now use your CR interface with jBASE, Cachi, SQL Server, or any other database - all you need to do is replace the DAL - and you can use the same DAL and BLL to provide data to MS Office, web services, or any number of other front-end application/interfaces. This also insulates you from support people at either IBM or CR blaming their faceless counterparts for some malfunction. Speaking of which, I'm surprised IBM says CR itself is so broken but I suspect that's motivated in part by their purchase of Cognos. As always, if you'd like assistance, you know where I am. :) HTH Tony Gravagno Nebula Research and Development Technical Editor, LINQ Programming: http://tinyurl.com/5lqroa [link goes to Amazon for book info] ... and other .NET books and publications TG@ remove.pleaseNebula-RnD.com Nebula R&D provides .NET-related development and training services > From: David Wolverton > We want to use UniData 7.1.20 OLE-DB and Crystal > Reports 2008 ... and IBM support tells me that CR > has 'not worked right since Version 9' (which in itself > is amazing, and unbelievable!) > > So I'm asking the masses -- are you using CR 2008 against > UniData 7.1.x? And if so, are there tricks you can share? ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008 7:06 PM ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.169 / Virus Database: 270.6.21/1675 - Release Date: 9/16/2008 7:06 PM ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
