Just to let everyone know, this is a bug. It was reported to IBM back in 2002, and it's still not fixed. They now have a new eCase for it, 7477, which is apparently in 'Advanced Tech Support' awaiting prioritization, etc...
If this is something you might like to do (a fairly standard request for a query design), please let IBM or your VAR know--I imagine the more interest that's shown, the more priority that will be placed on the eCase. Thanks, Amy -----Original Message----- From: Amy Cook Sent: Wednesday, January 19, 2005 7:22 AM To: '[email protected]' Subject: RE: [U2] UniData ODBC / Prompt for selection criteria Sorry, no I mean that I'm prompting from the 3rd party client. (i.e. in MSAccess, the selection criteria is [Please enter the fiscal year] ...or something to that effect... which would bring up the dialog box for the person running the query. In that example, if I enter 2004 in the dialog box, I get the error. If I enter 2004 into the selection criteria itself, the query works. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: Tuesday, January 18, 2005 9:54 PM To: [email protected] Subject: RE: [U2] UniData ODBC / Prompt for selection criteria Do you mean you're trying to do an <<inline>> prompt through an ODBC connection? You're a brave soul. I would prompt for imput in the 3rd party client and pass the full string through... hth Colin Alfke -----Original Message----- From: Amy Cook I know this issue has been reported to IBM (don't know what IBM calls it, but the 'bug' # is 144655). I'm trying to figure out if anyone has a workaround (or if this has been fixed at a later version). When I prompt for selection criteria from a 3rd party client (i.e. Access), the unidata odbc driver returns an error message - ODBC - Call Failed. If I hard code the answer to the selection criteria, instead of prompting for it, the query runs correctly. We're on version 5.2.8. Suggestions? [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- 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/
