RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread jpb-u2ug
?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note

RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread Anthony Youngman
PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility

RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread Marc Harbeson
PROTECTED] On Behalf Of jpb-u2ug Sent: Friday, September 19, 2008 9:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's

Re: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread Louie Bergsagel
Aye, matey, and since it is th' 13th annual International Talk Like a Pirate Day, http://www.talklikeapirate.com/we can say Shiver me timbers, and I'll stick wit' a LIST statem'nt! http://www.talklikeapirate.com/ On Fri, Sep 19, 2008 at 7:13 AM, Anthony Youngman [EMAIL PROTECTED]wrote: There

RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread jpb-u2ug
@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk

RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread David Wolverton
PROTECTED] On Behalf Of jpb-u2ug Sent: Friday, September 19, 2008 4:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker

RE: [U2] [UD] Crystal Reports and UniData

2008-09-19 Thread Tony G
From: Jerry Banker Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. (Dead topic for this group?) Despite claims and efforts, U2 is not IBM, where DB2 is. IBM's honorable influence doesn't drive all vendors for every bit

Re: [U2] [UD] Crystal Reports and UniData

2008-09-18 Thread David Peters
] 09/17/2008 05:09 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] [UD] Crystal Reports and UniData I agree with you 100% Tony from the independence makes things 'better' for people who are platform agnostic -- we're talking a 100% UniData

RE: [U2] [UD] Crystal Reports and UniData

2008-09-18 Thread David Wolverton
. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Anthony Youngman
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: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Marc Harbeson
If IBM knows CR has not worked right since Version 9 you would think IBM would have adapted their interface to strip quotes... Obviously CR running in other OLE-DB environments IS compliant. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Marc Harbeson
To: 'u2-users@listserver.u2ug.org' 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

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Anthony Youngman
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: 17 September 2008 14:57 To: u2-users@listserver.u2ug.org 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

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Marc Harbeson
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: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData But won't

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Anthony Youngman
] 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: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports

Re: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread DAVID WOLVERTON
@listserver.u2ug.org 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

Re: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread DAVID WOLVERTON
I agree with you 100% Tony from the independence makes things 'better' for people who are platform agnostic -- we're talking a 100% UniData solution in all cases, and the issue we're seeing more and more is that prospects want to see that the 'core engine' supports the ability to use BI tools

RE: [U2] [UD] Crystal Reports and UniData

2008-09-17 Thread Colin Alfke
We do have one client using UniData against Crystal Reports. We use ODBC for the connection and I'm not sure which version of CR they are using - but it does seem to work well. hth Colin Alfke Calgary Canada From: dwolvert [snip] That said, before I actually told the client Im working with that

RE: [U2] [UD] Crystal Reports and UniData

2008-09-16 Thread Tony G
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