on 09-29-2008 7:47 PM
Hi All,
I was able to add my new JDBC connection with no problems but I think I left something out. Here's the issue:
I can access the database until I try to put in a where clause or filter. When I look at Show Query, I should see thisin my where clause:
AND "tickets"."ticket_type"='IM'
I get this:
AND "tickets"."ticket_type"=N'IM'
I didn't put that into the select expert criteria so I'm not sure how it is being added into the query. Anyone have any ideas?
Thanks in advance,
Sandie
Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
There are a couple of things that were not indicated in your question
1. What kind of database are you using?
2. What version of Java are you using?
As for suggestions, what happens if you use a Command Object to explicitly state the SQL that you would like to use? Does it illustrate the same behavior?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.